MrExcel Publishing
Your One Stop for Excel Tips & Solutions

decimal places


Posted by charlotte on August 27, 2001 8:48 AM

Is there a way to change the actual decimal placement in a cell. I don't mean adding or taking away a decimal with zeros. I mean actually converting a number, ie, 8.1 to .081.


Posted by Dax on August 27, 2001 9:03 AM

If in an empty cell you type 0.01 then copy that cell. Next, highlight the cells whose values you want changing click Edit, Paste Special and select the Multiply check box.

HTH,
Dax.

Posted by Aladin Akyurek on August 27, 2001 9:13 AM

What should be the results of converting the following numbers?

8.1
78.2
8
0.9
112.45

Posted by charlotte on August 27, 2001 4:07 PM

I'm trying to find out how to move the decimal two places for the above examples. Is there a way to do that? THANKS!

Posted by charlotte on August 27, 2001 4:08 PM

Thanks! I will try it!

Posted by Aladin Akyurek on August 27, 2001 4:14 PM

Dax's suggestion will do. (NT)