Data corrupted in multipage spreadsheet

Hi,

I have a spread sheet that I've been maintaining/updating since 2005. It has 60 pages of financial data. I had copies in other places but I recently moved the main one to an alternate location and ran my backup batch which must have copied all the bad spreadsheets to the backup!
Now in all the sheets some of the financial data is there, but the number of shares columns all got filled with dates! I scoured all drives for other copies and did find a good one from July 2013 ouch! So I lost 6 months of data. I have Excel 2010 currently. I'm thinking possibly the file copy did it. But why mess up only certain columns?
Has anyone seen something like this? Am I hitting the limit on number of pages that Excel can reliably hold?

Thanks

Hi Coolecho,

Is it possible that you have a cell formatting issue?

It may look like you have dates, but if you highlight the column and format it as number (or general), you might get your data back.

Regards,

David


When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

David,
Wow that is exactly what happened! Amazing I never would have imagined. This saved me a ton of work! I'll just have to go thru and format paint back the correct formats.

Thank You so much!