View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marvin P. Winterbottom Marvin P. Winterbottom is offline
external usenet poster
 
Posts: 34
Default Excel auto deleting zero at start of cell - change?

format/cells/number/special/ssn

"SpclServFrtCo" wrote:

Entering SS# beginning with a zero in a cell - Excel auto defaults to next
number and deletes the zero - how do I change this default setting?