Tricky number formatting

J

JeffreyO

I don't know if this is even possible, but I'm building a spreadshee
that requires salary data in thousands rounded to nearest hundred (e.g
$53,817 = 53.8) I've got approximately 1400 employees on the report s
I don't really want to do each one "by hand." Is there a way to forma
this
 
T

Tim M

=(ROUND(A1,3))*0.001

See if this will do the trick, in the formula cell A1 is the 1st cell with
your salary data. you will have to format your column how you want the
numbers to appear (in your example your result was 53.8 so you would have to
format the column to numberic, 1 decimal)
 
R

Ron Rosenfeld

I don't know if this is even possible, but I'm building a spreadsheet
that requires salary data in thousands rounded to nearest hundred (e.g.
$53,817 = 53.8) I've got approximately 1400 employees on the report so
I don't really want to do each one "by hand." Is there a way to format
this?
Click to expand...

If you want to retain the "real number" of 53,817, you could use the custom
format:

Format/Cells/Number/Custom Type: #.0,




--ron
 
Top