Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
|
|
|
The UK's most regular 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
Resolved · Low Priority · Version 2003
Reply Fri 29 Oct 2010, 14:34Delegate Deborah said...
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.
For upcoming training course dates see: Pricing & availability
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.
|