Thread: how to stop general format automatically changing to custom
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default how to stop general format automatically changing to custom
Hi,

type an apostrophe first '

Mike

"Cori" wrote:

I am typing 2-12 in general format. Excel automatically changes format to
custom and enters 12-Feb. When I select cell and change change format back to
general, Excel then changes contents of cell to 39490. How can I enter 2-12
and have it remain 2-12?
Reply With QuoteReply With Quote