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!
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!