| 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 |
| 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 | |||
Threaded Mode
