How do I know the text or number within cell?

[Eric]

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

 

[Prashant Runwal]

use simple formula in b2
=abs(a2)
even if that number is stored as text you will get number in b2

 

[David Biddulph]

Numbers in Excel are limited to 15 significant figures.

 

[David Biddulph]

And when you make it a number, how many significant figures can you see,
Prashant?

 

[Ron Rosenfeld]

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?

You won't be able to do that in Excel. If you check Excel's specifications,
you will discover that it has 15 digit precision.
--ron

 

[Eric]

For my case, in cell A2, there is char 2328050010001023841. The value must be
string instead of number based on Excel's specifications has 15 digit
precision.

If I get a list of string under A column, does anyone have any suggestions
on how to sort it in ascending order based on macro coding?
Thank everyone very much for any suggestions
Eric

 

[Prashant Runwal]

Dear Eric,

If you have stored strings which are more than 15 char long, then during
sort warning select sort numbers and numbers stored as text seperately. I
have tried this and is giving desired result.