Excel format in selected cells have changed to DATE format!!!!

G

Guest

OMG! This is destroyed my spreadsheet, it has happened before...
randomly certain cells are changed to DATE format, the NORMAL style
changes to DATE format. Changing the normal style back to 'General'
number format worked last time, this time, it has ravaged my
spreadsheet.

What is causing this? I saw this bug mentioned by other people in
other posts. What is causing this bug, and how can i avoid it from
happening again?
 
B

Bob I

You are placing text in the cells that look exactly like dates. Format
the cell as text or place a ' in the cell before the text when you place
that info in the cell
.ie '2-20
 
J

John

This is a real bug and has happened to me and others many times. Something
triggers Excel to switch all cell formats in a Worksheet to dates.
 

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

date format in excel imported from an SQL DB. 2
Remove date format? 3
Data exported to excel 2007 changes cell number format to 'general' ? 1
Excel How to change the "Short Date" format in Excel? 4
all cells in 2 workbooks have automaticlly changed to date format 1
Excel 2007 Saving Cell types in XLS format 1
All “General†values changed to “Date†format 1
How to stop excel 2007 automatically changing my date format? 2

Top