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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
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.
 
Back
Top