View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Excel Auto correct

You cannot change this feature through autocorrect.

Preformat the cells as Text or precede the 10-19 with an apsostrophe.

i.e. '10-19

The apostrophe won't show in the cells.


Gord Dibben MS Excel MVP

On Sun, 28 Oct 2007 12:32:01 -0700, dustin
wrote:

How do i change auto correct in Excel so it doesnt change my numbers (10-19)
in a cell to a date (Oct 19)