Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 29th 09, 02:44 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2009
Posts: 1
Default Keep text out of numeric field

I am trying to "idiot proof" a worksheet. I know how to protect and
unprotect cells and worksheets...

What I am trying to do now is to make it so that someone cannot enter text
in a numeric field. I have not figured out how to do that yet. I would
think it would be rather common, but I don't see how it is done.

Thanks in advance.
Diane


  #2   Report Post  
Old September 29th 09, 05:50 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 515
Default Keep text out of numeric field

Select the cells you want to use for numbers.
Click on Data Validation. Change the block that says Allow Any value to
Allow Whole Numbers or Decimals, depending on what you want, set the criteria
to greater than and make it 0 or 0.01. You can only enter those values then,
and not any text. Rather, you can type text into such a cell, but when you
press <Enter, an error message pops up, stating that you cannot insert text.

--
HTH

Kassie

Replace xxx with hotmail


"Diane" wrote:

I am trying to "idiot proof" a worksheet. I know how to protect and
unprotect cells and worksheets...

What I am trying to do now is to make it so that someone cannot enter text
in a numeric field. I have not figured out how to do that yet. I would
think it would be rather common, but I don't see how it is done.

Thanks in advance.
Diane




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
//sk - Max length of a numeric field. sansk_23 Excel Worksheet Functions 4 September 25th 09 06:12 AM
Numeric in Text to convert back to the form of Numeric for VLookup Purposes achilles Excel Discussion (Misc queries) 4 February 6th 06 08:05 AM
Merge an alpha field and a numeric field grams Excel Discussion (Misc queries) 3 August 29th 05 11:33 PM
how do i step thru a text field looking for 6 numeric characters Snookman150 Excel Worksheet Functions 0 June 30th 05 01:31 PM
Sort a numeric field sdmccabe Excel Discussion (Misc queries) 5 June 28th 05 08:54 AM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017