Split Column by Delimiter - Keeping the Delimiter

[Carin]

I have a column with decimals (18.73). I want to split the column to have the whole number in one column (18) and the decimal in the other column (.73). I am able to split; however, the decimal is displaying (73).
The output of the data has formulas for custom rounding to a whole number and my formula thinks this is 73 not .73. Any help would be appreciated. I am BRAND NEW using Power Query.

 

[Norie]

Don't split the column, add 2 new columns via Add Column>Custom Column.

The first one would use a formula like this to get the integer part,

= [Employees Approved] - Number.Mod([Employees Approved],1)

and the second this to get the decimal part.

= Number.Mod([Employees Approved],1)

 

[Carin]

That works beautifully! I wish I better understood how it worked I'll get there. Thank you very much.