View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
 
Posts: 117
Default 1-4-1 is not a date how do I stop excel from changing whats enter

Enter an apostrophe before your data

'1-4-1
'1-4-2

"Perry Monroe" wrote:

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