Thread: Allow only nummeric values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sapai sapai is offline
external usenet poster
  
Posts: 9
Default Allow only nummeric values
Hi,

I have a requirement wherein I need to format the sheet to accept only
numerical values. Any other data (numerical or special characters) should be
changed to "N/A". is this possible in Excel ?

Thx
SPA
Reply With QuoteReply With Quote