View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

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