Thread: Check numeric char
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Check numeric char
Try the below....returns TRUE if a number...

=ISNUMBER(--SUBSTITUTE(A1,",",))

--
Jacob (MVP - Excel)


"Kash" wrote:

Can anyone help with a formula/macro to check if a cell contains all numeric
characters only? in which only "," can be allowed and not even a space.
Reply With QuoteReply With Quote