View Single Post
  #1   Report Post  
mjk
 
Posts: n/a
Default Excel default date format


1) The default date format for Excel is "21-Mar" when I enter date
recognized data. This is unusable for me, I need the year displayed. How do I
change the default date format to display the year.

2) With default also, Excel sometimes requires "=" in equations and
sometimes not; i.e., if I enter a '-' it converts the cell to an equation.
How do i stop this so that it only makes equations when I enter '='.

3) How do I get help on Excel inconsistancies like the above in Excel
documentation anywhere?

mjk