Thread: column formatted to general - cells keep changing to date?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote