simple ?

J

John Mansfield

Since there is a zero in front of the number, it's possible that Excel is
reading the number as text as opposed to a value. To convert your "text"
number to an actual value, you can use the VALUE worksheet function. For
example, if cell A1 contains "0016", add this formula to cell A2
"=VALUE(A1)". The value returned in cell A2 will be 16.
 
G

Gord Dibben

To enter a number like 01234 you must pre-format the cell as text or enter an
apostrophe then 01234.

The "number" will be text and not usable in a formula.

OR enter 1234 and custom format to 00000 which will allow 1234 to be a real
number.


Gord Dibben Excel MVP
 
Top