Change the formula to =ROUND(A1/0.645,0)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Angie33" wrote in message
...
I need help formatting some numbers. I have column "A" with numbers. In
column "B" I have a formula "A1/0.645" the number comes out as
"10.85271318"
when I decrease the decimals all the way it turns to "11". When I copy
and
paste special with "value and format" it past it in as "11" but the
formula
bar has the full number. Is there any way to past this value just as "11"
with out the entire number showing in the formula bar or any where else.
I
just need the actual number. What can I do to make this happen?
Angie33