column formatted to general - cells keep changing to date?
 

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.

column formatted to general - cells keep changing to date?
 

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

On Thu, 11 Sep 2008 08:45:08 -0700, lilsparkdog
wrote:

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.