How do I know the text or number within cell?

E

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
 
P

Prashant Runwal

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

David Biddulph

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

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
 
E

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
 
P

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top