View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How do I know the text or number within cell?

In cell A2, there is char 2328050010001023841.
I am not sure whether the char is text or number, does anyone have any
suggestions on how to force it into number?
I have tried following code, but it misses the last 4 digits.
In cell B2, Int(A1) = 2328050010001020000.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric