Column with Text and Decimal Numbers

[exodusme]

Hello, I have a column that has both text and numbers in it that is imported from excel. When I bring the column into powerquery it adds a bunch of decimals to it. Not sure what is up. I try to edit it in the excel file and that is fine there, so I don't know what to do.

[slorin]

Hi

Round only if type = number

Table.TransformColumns(Your_Source,{{"Your_Column", each if Value.Type(_) = type number then Number.Round(_,2) else _}})

Stéphane

[exodusme]

Table.TransformColumns(fact_UID,{{[Unique ID Number], each if Value.Type([Unique ID Number]) = type number then Number.Round([Unique ID Number],2) else [Unique ID Number]}})

I am getting "Expression.Error: A cyclic reference was encountered during evaluation"

I am guessing I am not using the appropriate formatting for the expression? Not sure where I went wrong though. Thank you for your time.

[slorin]

Table.TransformColumns(fact_UID,{{[Unique ID Number], each if Value.Type(_) = type number then Number.Round(_,2) else _}})

Stephane 

[exodusme]

still getting the cyclical reference =\

[Greg_Deckler]

@exodusme Maybe try rounding it?

[exodusme]

the column also contains text that i cannot round