column formatted to general - cells keep changing to date?

  • Thread starter Thread starter lilsparkdog
  • Start date Start date
L

lilsparkdog

In my spreadsheet I have a particular column that I have formatted to general
but anytime I enter numbers into a cell in that column, it automatically
changes it to a date and I have to re-format that cell to general.
 
What type of numbers?

Like 1-12 or similar?

Pre-format the cells as Text or preface the numbers with an apostrophe.


Gord Dibben MS Excel MVP
 
Back
Top