Need to Force a Data Column to Make Numbers into Text in the Form of XX.XX

Thanks for this. I struggled with it (I'm not the brightest) but to no avail. However, your answer prompted me to success. It's certainly not elegant, but here's what I did...

Split the column at the "." delimeter.

Renamed the two new columns, "Half_1" and "Half_2"

Created 2 custom columns:

• = Text.PadStart( [Half_1], 2 )
• = Text.PadEnd( [Half_2], 2 )

This put a space any time there was not 2 digits

Then I went and did a Find/Replace " " with "0"

Then concatenated the two columns: = [Half_1] & "." & [Half_2]

Long way to do it, but it worked!

Thanks to all, your post prompted me in a successful direction!

Jase.