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

How do I know the text or number within cell?
 

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


"Eric" wrote:

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

How do I know the text or number within cell?
 

Numbers in Excel are limited to 15 significant figures.
--
David Biddulph

"Eric" wrote in message
...
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

How do I know the text or number within cell?
 

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

"Prashant Runwal" wrote in
message ...
use simple formula in b2
=abs(a2)
even if that number is stored as text you will get number in b2


"Eric" wrote:

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

How do I know the text or number within cell?
 

On Sun, 18 May 2008 03:25:00 -0700, Eric
wrote:

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

How do I know the text or number within cell?
 

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


"Ron Rosenfeld" wrote:

On Sun, 18 May 2008 03:25:00 -0700, Eric
wrote:

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

How do I know the text or number within cell?
 

Hi. In general, when one sorts strings like
"2328050010001023841"
and
"567"

Excel looks at the first character and will sort the string beginning with 2 before the string starting with 5
A general method might be to pad all string with 0's in the front to form a standard length string... then sort.
There are many ways to do this, but in general, perhaps form a new string from "567" by using something like this. (A2 is 567)

=RIGHT("0000000000000000000" & A2,19)

If you sort on this newer string, it should work as you expect.

--
HTH :)
Dana DeLouis


"Eric" wrote in message ...

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


"Ron Rosenfeld" wrote:


On Sun, 18 May 2008 03:25:00 -0700, Eric
wrote:


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

How do I know the text or number within cell?
 

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.

"Eric" wrote:

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


"Ron Rosenfeld" wrote:

On Sun, 18 May 2008 03:25:00 -0700, Eric
wrote:

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