Data Formatting Error

victorsm

Guest

Posts: n/a

10th Dec 2007

I am using Windows XP SP2 with MS Office 2007. I have a spreadsheet that is
in proper condition. After working on it, I save and close the spreadsheet
for later use. Upon opening the sheet at a later time, all of the cells that
had a data type of "number" are now converted to data type of "date". The
cells contain the correct values, however the cells display as "#####". I
can convert the cell type back to "number" and the values display correctly.
I cannot figure out why this is happening every time a save, close and then
reopen the file. Can any one help me with this?

« Hyperlink Error in Excel when using # | no auto sum formulas remain when I save to different file name »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ERROR: "Unable to save data and formatting"	=?Utf-8?B?R2l6bW82Mw==?=	Microsoft Excel Misc	0	30th Apr 2007 12:20 PM
error: Excel encountered an error and had to remove some formatting to avoid corrupting the workbook; please recheck your formatting carefully	Keith	Microsoft Excel Programming	0	31st Jan 2007 05:38 PM
Why this error ?: Excel could not save all the data and formatting	=?Utf-8?B?bWFueG1hbg==?=	Microsoft Excel Misc	0	4th Oct 2006 04:54 PM
How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)	ship	Microsoft Excel Discussion	22	25th Apr 2006 06:02 PM
How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)	ship	Microsoft Excel Misc	23	25th Apr 2006 06:02 PM