How do I stop from converting numbers (e.g 3-30) into dates

  • Thread starter Thread starter Proft
  • Start date Start date
P

Proft

I'm trying to enter records into a spreadsheet. everytime i Try to use a
dash, it converts into a date
 
Either pre-format the input column as text (via Format>Cells)
Or precede the data entry with an apostrophe
 
Back
Top