Data type
What a column's values mean: text, whole number, decimal, date, logical and so on. Types drive comparisons, sorting and what downstream tools see.
Types decide how values compare and sort: as text, "10" sorts before "9". A column typed any can hold mixed values and loads as text in many tools. Setting types explicitly right after import, and again after appends or expands, prevents most downstream surprises.
In the Power Query editor
The icon at the left of each column header shows its type (ABC for text, 123 for whole number, a calendar for date).
Learn more
Related functions
Practise it
- beginner~6 minFree
Keep order numbers' leading zeros (kite shop)
Type a CSV so order numbers stay text (0007, not 7) while quantities and prices become numbers.
- intermediate~7 minFree
Split a timestamp into its date and hour (door access)
Each event has a text timestamp like 2026-03-04T14:30:00. Add a real Date and the Hour of day.
- beginner~5 minFree
Make a mixed number/text code column all text (garden centre)
Product codes arrive as a mix of numbers (1001) and text (A-17, 0042). Make every code text.
- beginner~5 minFree
Build a date from year, month and day columns (deliveries)
A legacy export stores dates as three number columns. Combine them into one real date.