Thread: Prevent alpha character from being entered into a numeric field
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
M Kan M Kan is offline
external usenet poster
  
Posts: 169
Default Prevent alpha character from being entered into a numeric field
Go to the Main Menu: Data: Validation. From there, you can set the
parameters on what can be entered into the cell as well as input and error
messages.

http://www.kan.org/tips/excel_validation.php
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Brazil" wrote:

How can I protect a cell so that an alpha character cannot be entered into a
numeric field?
Reply With QuoteReply With Quote