showing a zero in a cell

Topic

New Reply

I’m really sorry about this guys, but I can’t remember how to get a zero to show in a number that I am entering into a cell. I looked in the excel options advanced and all I see in there is show a zero in cells that have a zero value, and that is checked…. I’m really embarrassed.. Oh Office ’07.
Humbely John

Reply | Quote

Replies

John,

Where is the zero in the number? Are you talking about leading zeros as in 007? if so you need to setup a custom format :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Yup I am talking about a leading 0. Thanks RG!

Reply | Quote

Yup I am talking about a leading 0. Thanks RG!

You can set a custom format for the cell Ctrl+1, Select “Custom” for the category. and put 000 in the Type

or you can use =TEXT(A1,”000″) if you want to change the format that way.

Reply | Quote