Forum Discussion

gnarnah's avatar
gnarnah
Copper Contributor
Oct 22, 2020
Solved

TEXT function keep 2 decimal places

Hello, So i am trying to convert our price list to text with "00000000" (8 0's). I want to keep 82.50 as 00008250. I can't find anything to help me do this? Thank you!!  
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Oct 22, 2020

    gnarnah 

    With TEXT() function you may use something like this

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 22, 2020

gnarnah 

With TEXT() function you may use something like this

  • gnarnah's avatar
    gnarnah
    Copper Contributor
    Oct 22, 2020
    Yes thank you!!!

Resources