power query data format

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Power Query data format

Power Query data format

resolvedResolved · Low Priority · Version 365

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

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.


 

Excel tip:

Editing a formula quickly

If 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

View all Excel hints and tips


Server loaded in 0.87 secs.