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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determining How An Existing Cell Is Formatted ? 4
How do I stop a general format from being autoformatted to date 2
Count number of cells with date <today's date 2
unwanted cell formatting 1
Leading Zeros; How to Keep ? 2
Remove date format? 3
data to summary sheet for a dummy 0
Column title automatically changes? 2

Top