How do I type number that begins with a zero to keep zero?

[Guest]

I am typing last four digits of social in cells and ones that begin with
zero, will not hold the zero. How do if fix this? thanks Vickie Newto

 

[DNA]

Format the cell as Custom and under the "Type" section type 0000.

HTH

 

[Guest]

Format the cells as "Text".... Format->Cells->Click on "Text"

 

[Dave Peterson]

Give the cell(s) a custom format of 0000.
Format the cells as text, then type your entry.
Start your entry with a leading apostrophe: '0012

The first one will keep the value numeric. The bottom two will treat your value
as text.

 

[AlfD]

Hi!

Format the cell as text before you fill it.

Use Format > Cells...>Number>Text.

It won't be a number anymore, but I can't imagine you want to calculate
using it...

Alf