| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy selected part number of text from one cell into another cell | Excel Discussion (Misc queries) | |||
| display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
| count number of specified text within a text/cell | Excel Discussion (Misc queries) | |||
| have one cell display text which reflects a number in another cell | Excel Discussion (Misc queries) | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Linear Mode
