98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Power Query data format
Power Query data format
Resolved · Low Priority · Version 365
Mon 24 Apr 2023, 10:27Delegate Filip said...
Filip has attended:
Excel Intermediate course
Power Query data format
Hi Jens,
Just wonder if Power query from definition keeps the data Number format as the original Csv file, or if this has to be edited for each column separately. I've found some issues with calculating some numbers from queried tab by existing Pivot.
Thanks,
Filip
Mon 24 Apr 2023, 11:04Trainer Jens said...
RE: Power Query data format
Hi Filip,
Thank you for the forum question.
Power Query will analyse the data and determine the data type. Power Query will not keep the data Number format as the original Csv file.
Power Query will look at each column and if you have numbers in the column, it will number format the column.
You can change the formats in Power Query. Power Query will remember the steps so it will do exactly the same steps when you add more data.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Sat 6 May 2023: 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:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |
