Forum Discussion
kekepania0529
Helper I
Helper IFixed Decimal Number converted to Text issue
I converted a fixed decimal number column to text. Once converted, if the digits after the decimal were zeros, or the last digit was zero, they are being dropped from the text. How can keep the zeros...
Try adding SUBSTITUTE function as well
so New Column = SUBSTITUTE( FIXED (TableName[1_GL_Account],2), ",", "")
kekepania0529Helper I
Helper IThat worked for the decimals, but added commas to the string. Can the commas be removed also? It needs to be formatted like this: 3219001011.05
themistoklis
Community Champion
Community ChampionTry adding SUBSTITUTE function as well
so New Column = SUBSTITUTE( FIXED (TableName[1_GL_Account],2), ",", "")