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

Remove date format? 3
date format in excel imported from an SQL DB. 2
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
all cells in 2 workbooks have automaticlly changed to date format 1
All “General†values changed to “Date†format 1
Data exported to excel 2007 changes cell number format to 'general' ? 1
How to stop excel 2007 automatically changing my date format? 2
Default format changed in Excel 2007 0

Top