Thread: Prevent alpha character from being entered into a numeric field
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Brown[_4_] Gary Brown[_4_] is offline
external usenet poster
  
Posts: 209
Default Prevent alpha character from being entered into a numeric field
Assuming your cursor is in Cell A1:
Use Data Validation.
From the top menu, select...
Data Validation Settings Allow
Select Custom
For 'Formula', put...
=ISNUMBER(A1) = TRUE
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"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