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 » Pivot tables
Pivot tables
Resolved · High Priority · Version 2007
Adrian has attended:
Excel Advanced course
Pivot tables
How to create pivot tables of airline schedule info. (using multiple consolidation ranges and text to columns), where arrival/departure time reflects original data (whereas it now formats as a decimal point eg. 0.000123)
RE: Pivot tables
Hi Adrian
Thank you for your question
It is difficult to advise you without seeing the spreadsheet in question. Could you email a copy of the workbook to me at stephen@stl-training.co.uk and I will investigate and reply
Regards
Stephen
RE: Pivot tables
Hi Adrian,
Did you manage to get a copy of your workbook to Stephen?
This question has now been left unattended for a while.
We like to keep down the large number of active forum posts we receive.
As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).
We look forward to hearing from you.
Thank you.
Regards, Rich
RE: Pivot tables
Hi Rich,
Sorry - meant to send it earlier. Which file do you want to have a look at - the Mr. Excel one or my own? Please advise.
Adrian.
RE: Pivot tables
Hi Adrian
If you could send me a copy of both files, I will endevour to solve the issue for you
Regards
Stephen
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:Change the default location for opening and saving spreadsheetsIf you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to. |