Forum Discussion

kekepania0529's avatar
kekepania0529
Helper I
4 years ago
Solved

Fixed 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...
Need Help
  • themistoklis's avatar
    themistoklis
    4 years ago

    Try adding SUBSTITUTE function as well

     

    so New Column = SUBSTITUTE( FIXED (TableName[1_GL_Account],2), ",", "")

Pragati11's avatar
Pragati11
Super User
4 years ago

HI kekepania0529 ,

 

Can you share your sample data here so that I can try it at my end?

 

Thanks,

Pragati