simple ?

I'm trying to add a number to a cell that begins with 0 and i can't. why?????
--
Thank you

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.

----
Regards,
John Mansfield
http://www.pdbook.com

"Novice25" wrote:

> I'm trying to add a number to a cell that begins with 0 and i can't. why?????
> --
> Thank you

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

On Thu, 3 Mar 2005 16:35:01 -0800, "Novice25"
<[email protected]> wrote:

>I'm trying to add a number to a cell that begins with 0 and i can't. why?????