changing how numbers appear

  • Thread starter Thread starter tom donino
  • Start date Start date
T

tom donino

I want a cell on my spreadsheet to show a number, for
example, 8,000,000 as $8 mil. Is this possible? Or if the
number is say 8,536,000 it will show $8.54 mil. The
original number is a manual input into the spreadsheet
 
Hi Tom

not sure you can do it in the same column as the original number, but say
your original number is in cell A1, in B1 you could use the following
formula
=ROUND(A1,-4)/1000000
and then use a custom format on B1 that looks like this
$#,##0.00 "mil"
or
$#,##0.## "mil"

Hope this helps
Cheers
JulieD
 
Hello Tom,
Since the data is manually input, set up the cells using Julie's first
custom format and just make sure you enter the data with the decimal
point after the digit or digits for million.
 
Hello Tom,
Since the data is manually input, set up the cells using Julie's first
custom format and just make sure you enter the data with the decimal
point after the digit or digits for million.
 
Back
Top