Forum Discussion
kekepania0529
Helper I
4 years agoFixed 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...
- 4 years ago
Try adding SUBSTITUTE function as well
so New Column = SUBSTITUTE( FIXED (TableName[1_GL_Account],2), ",", "")
Pragati11
Super User
4 years agoHI kekepania0529 ,
Can you share your sample data here so that I can try it at my end?
Thanks,
Pragati