numeric format

[Rocket J Squirrel]

Is there a way to set the default numeric format so that 0s in front of
the number show in the cells? E.g., if I input 0033421, the cell shows
33421 UNLESS I put an apostrophe in front of it, as in '0033421. I'd
like to skip the apostrophe if possible.

 

[Guest]

Is there a way to set the default numeric format so that 0s in front of
the number show in the cells? E.g., if I input 0033421, the cell shows
33421 UNLESS I put an apostrophe in front of it, as in '0033421. I'd
like to skip the apostrophe if possible.

Select Format>Cells and go to Number>Category>Custom then clear the Type
field and enter some 0's and watch what happens to the sample. When it
displays what you want to see, click OK

 

[Rocket J Squirrel]

:




Select Format>Cells and go to Number>Category>Custom then clear the Type
field and enter some 0's and watch what happens to the sample. When it
displays what you want to see, click OK

Thanx. I'll try it tommorrow.