LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 123
Default Prevent alpha character from being entered into a numeric field

Select Data/Data Validation and select either whole number or decimal
from the list to restrict the cell to that type of content. You get to
set a min and max and can set up an input message (that appears when
the cell is selected - like a comment that responds to selection not
mouse position) and an error message.

On Jul 21, 1:48*pm, Brazil wrote:
How can I protect a cell so that an alpha character cannot be entered into a
numeric field?


 
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
Prevent alpha character in numeric cell Brazil Excel Discussion (Misc queries) 2 July 21st 08 09:28 PM
PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER Gautam Mandal Excel Worksheet Functions 0 March 28th 07 02:03 AM
PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER Greg Wilson Excel Worksheet Functions 0 March 28th 07 01:56 AM
PICTURE RECOGNITION AS A ALPHA-NUMERIC CHARACTER Greg Wilson Excel Worksheet Functions 0 March 28th 07 12:15 AM
Merge an alpha field and a numeric field grams Excel Discussion (Misc queries) 3 August 29th 05 11:33 PM


All times are GMT +1. The time now is 06:35 AM.

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"