simple ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to add a number to a cell that begins with 0 and i can't. why?????
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
Currency autofit 5
how to format cell in excel for 12 digit number starting with a 0 2
Adding Quote Marks To A Very Long Column. How, Please ? 1
Excel Need Countifs Formula Help 0
Simple Formula displays "0" 1
problem with fractions to decimal 1
Question about conditional formatting of zeros in Excel 0

Back
Top