Preceding Zeros

[khansen97]

Thismay be a stupid question, but I have completely run out of options.

I want when I enter in 00002 into a cell to show up as it appears. Right now it is converting it to 2.

When I try to format the cell as text it still give me a 2. Its only if I enter is as '00002 will it return exactly like how I want it.

The problem with that is I have imported the file and my 00002 keeps coming in as the 2 and I need someway of getting it back to 00002 without having to re-type 5000 record numbers.

Any suggestions?

thanks!

 

[AnotherHiggins]

Format>Cells
On the Number tab, choose "Custom"
In the box at the top right, type in 0000#

This will force all numbers to 5 digits

John

Every generalization is false, including this one.
-Unknown

 

[cLFlaVA]

Select the cells in question.
Go to Format > Cells.
On the Number tab, scroll down to Custom.
A Textbox will appear.
Enter this: 0000#

Click OK.

*cLFlaVA
----------------------------
A pirate walks into a bar with a huge ship's steering wheel down his pants.
The bartender asks, "Are you aware that you have a steering wheel down your pants?"
The pirate replies, "Arrrrr! It's driving me nuts!

 

[cLFlaVA]

you beat me higgins.

*cLFlaVA
----------------------------
A pirate walks into a bar with a huge ship's steering wheel down his pants.
The bartender asks, "Are you aware that you have a steering wheel down your pants?"
The pirate replies, "Arrrrr! It's driving me nuts!

 

[AnotherHiggins]

HA!

BTW, cLFlaVA, I've been telling *everyone* the joke that you have as a siggie. I just love it!

John

Every generalization is false, including this one.
-Unknown

 

[cLFlaVA]

Thanks!
Although I've considered changing it recently. Gotta keep the jokes fresh. That is, if we'll ever be able to change our sig's again...

*cLFlaVA
----------------------------
A pirate walks into a bar with a huge ship's steering wheel down his pants.
The bartender asks, "Are you aware that you have a steering wheel down your pants?"
The pirate replies, "Arrrrr! It's driving me nuts!