View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how to force excel not to change date?

You could either:
Preformat the cell as text (format|cells|number tab|Text), then do the data
entry.

Or you could prefix your entry with an apostrophe:
'3-4



tgi wrote:

I want the cell to have 3-4 but it keeps changing it to 4-Mar.


--

Dave Peterson