• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Turn 5,222 into 5,222,000...

Status
Not open for further replies.
J

jason

Member
WHOA, its been LOOOOONG time...

So I'm working with several numbers that are stored as 5,222 in the cell, but the number represents an assume 'millions'. meaning that if the cell shows 5,550 it represents 5,550,000. I'm trying to create a chart based on this but the chart will obviously plot at the 5THOUSAND level and not 5MILLION.

how can I add those last 3 zeros to all of my numbers? formula?

Thank you for your help!
 
Status
Not open for further replies.
Back
Top