Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data changed in the back-up spreadsheet
I saved an excel speadsheet with a different file name and all the number
values changed except for the dates. The original sheet had no formulas on it and all the new numbers have a decimal place followed by lots of numbers. I don't need to retrieve the old numbers as I backed it up successfully elsewhere but I don't want this to happen again. Any ideas? |
#2
|
|||
|
|||
My first thought is user error. But I can't think of how this could happen by
accident. My second thought was that maybe the original worksheet always had those decimals, but the format of the cell hid them: #,##0. If you select a cell and then look at the formulabar, do you see any decimals? == I've never seen excel do anything like this on its own. Plank wrote: I saved an excel speadsheet with a different file name and all the number values changed except for the dates. The original sheet had no formulas on it and all the new numbers have a decimal place followed by lots of numbers. I don't need to retrieve the old numbers as I backed it up successfully elsewhere but I don't want this to happen again. Any ideas? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Limiting Data Obatined By A Graph From A Spread Sheed | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |