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.
Vickie Newton wrote:
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
--
Dave Peterson
|