Thread: data alteration
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ben87y ben87y is offline
external usenet poster
 
Posts: 1
Default data alteration

how do I stop excel from altering inputted data?

eg "03/2009" is reformatted to 01/03/2009, or Mar-09, seemingly at random

I've tried right click format call then selecting general, but it
constantly reverts back to a "date" display.

Can I turn off this "autocorrect" alltogether somewhere?

Thanks Ben