Thread: Excel auto deleting zero at start of cell - change?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Excel auto deleting zero at start of cell - change?
You can't change this behavior but you can work around it.

Enter an apostrophe before typing the SS number.

OR format the cells to Text before entering the SS number.


Gord Dibben MS Excel MVP

On Mon, 26 Nov 2007 06:52:02 -0800, 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?

Reply With QuoteReply With Quote