Turn off automatic date conversion?

  • Thread starter Thread starter Geoff Offermann
  • Start date Start date
G

Geoff Offermann

I need to copy and paste some hockey scores to a spreadsheet. Unfortunately,
Excel likes to convert the scores to dates (e.g. 4-1 is turned into 1-Apr).

How do I turn this annoying #^$% function off?

On a related note, can you change the default format? I mean, does anyone
actually use the above format outside of Pluto?
 
Options would be to enter the scores as text (precede with an apostrophe --
shows up in the formula bar but not in the cell), or pre-format the cells as
text via Format -- Cells -- Number -- Category.

HTH,
Andy
 
You can either pre-format the cell(s) as text or precede the
entry with an apostrophe ' upon entering (it's not visible). You cannot turn
it off
I'm afraid..
 
Back
Top