Forum Discussion

jburklund's avatar
jburklund
Icon for Helper III rankHelper III
6 years ago
Solved

Help with billions number formatting

I am trying to format the number $1,558,753,918 to read $1.56B   I would use the built in billions formatting but it uses "bn" instead of "B" after a number.   I have tried using the format funct...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    I used this and I am getting $1.56B

     

    Measure = format(1558753918,"$#,,,.##B")
     
    Just make sure the data which you are formatting is number.
  • jburklund's avatar
    jburklund
    Icon for Helper III rankHelper III
    6 years ago

    Thank you v-chuncz-msft but this still just gets me to $1B. I need it to also show to the nearest millions, i.e. $1.56B.

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      6 years ago

      Try giving ## after decimal too

      • jburklund's avatar
        jburklund
        Icon for Helper III rankHelper III
        6 years ago

        Thanks but now I get $.01B