Putting 0's in Database

  • Thread starter Thread starter a.alejandro
  • Start date Start date
A

a.alejandro

Is there any way to format a cell so you can zeros in infront of a number?
For example, I want it to say 0040166071564 but what comes up is 40166071564.
HELP!
 
Preformat the cell (or range of cells) as text. Then do the data entry.
or
Start the entry with an apostrophe: '0040166071564
or (maybe)
give the cell a custom number format:
0000000000000

Select the range
format|cells|Number tab|custom category, type that string of 0's in the Type
box.
 
Hi there,

Select the cell(s) you wish to format and go to the Format menu, Cell,
Number command. Select the Custom category. If you need 13 digits instead
of 11, type thirteen zeros in the Type section. This forces non-significant
zeros in front of your number.

Hope this helps!

Donna
 
Back
Top