Formatting Number - Is there any way I can the actual value instea

A

Angie33

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
 
M

Muhammed Rafeek M

Use round function and paste special as value: =round(A1/0.645,0)
or just copy formatted entire column and paste to note pad, again copy from
notpad and paste to ur actual column


pls do rate
 
Top