LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
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

 
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 07: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 02:58 PM.

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

About Us

"It's about Microsoft Excel"