column formatted to general - cells keep changing to 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.
 
G

Gord Dibben

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
 
Top