Date auto format

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

When I type"1-2000"in a cell, it automatically changes to
show "Jan-00". It is not a date that I am entering so I
want it show as "1-2000". I change the cell format
to "general", then as soon as I enter the text, the format
changes to "date". How can I get the cell to not
automatically revert to the date format?
 
Either pre-format the cell as Text (for that's what it is), or
prefix the entry with an apostrophe:

'1-2000
 
Hi Jeff!

You can use:

Format > Cells > Custom Format
m-yyyy

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top