Help!!!

E

eylul

Hi all,

I want to put zeros before a number (000009999) but when I click ente
the zeros disappears. I changed the format to text then align right i
is ok. But it is not a number yet. Cause of this I can't use thi
method.

Is there anyone who can tell me how I can solve this problem.

Thanks in advance
 
A

Arvi Laanemets

Hi

Set format to Custom, and then in Costom Format window into Type field enter
as much 0's you need! Like 000000
 
S

Stefan Hägglund [MSFT]

If you don't use the number for calculations, you can set the format for the
cells to Text

Stefan Hägglund
Microsoft
 
L

Lisa Beach

I have had a similar problem and have usually been able to fix it by using
custom format with the number of 0's that you want to show and then ### for
the number of characters after the 0's.
Examle: 00098765
Format: 000#####

If the number of zeros varies then use the max number of zeros.


Hi

Set format to Custom, and then in Costom Format window into Type field enter
as much 0's you need! Like 000000
 
D

Dave Peterson

After you change the format, try reentering the data.

Just changing the format doesn't affect the value of what's in the cell--and
it's still text.

But when you reenter it (select the cell, hit F2, then enter is enough), excel
will see that as a change and see your "new" entry as a number.
 
Top