98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
Deborah has attended:
Excel Introduction course
Excel
Why did my excel spreadsheet suddenly open in date format from normal? Every sheet was effected too and I can't remember deliberately selecting it and changing to to date format.
RE: Excel
Hi Deborah,
Thank you for your question and welcome to the forum.
The next time you open up the spreadsheet select all the sheets using shift and click. Select the first sheet, hold the shift key down and click on the last sheet and all of them will be selected.
Select all the data and try and change the formatting back to the desired one.
Then save and close if you are happy it has worked. If not don't save the changes.
Alternatively send me the spreadsheet and I will have a quick look at it.
Let me know if this works.
Regards
Simon
Fri 5 Nov 2010: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing Multiple Workbooks quicklyWhen you have several workbooks open in Excel and want to just close them all at once: |