Thread: 1-4-1 is not a date how do I stop excel from changing whats enter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default 1-4-1 is not a date how do I stop excel from changing whats enter
Precede your entry with an apostrophe (').

Regards,
Fred

"Perry Monroe" <Perry wrote in message
...
is there anyway to stop the auto format I need to enter
1-4-1
1-4-2
1-4-3 etc...
and the data showes up as dates in the cells I hate this auto function and
I
would like to shut all auto features off they never help

Reply With QuoteReply With Quote