software

Is there an easy way to move the decimal point other than adding a column and
dividing by 100 then deleting wrong numbers?

THanks,
Donna

Put 100 in a cell copy it, select the range you want to divide and do
editgt;paste special and select divide
delete cell with 100, only one extra cell used To get 8.00 out of 800 you
need to use number format like
0.00 or else it displays as 8

--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Donnaquot; gt; wrote in message
...
gt; Is there an easy way to move the decimal point other than adding a column
gt; and
gt; dividing by 100 then deleting wrong numbers?
gt;
gt; THanks,
gt; Donna
Enter 100 into any blank cell
Copy that cell
Select your range of data to convert
Select quot;Paste Specialquot;
Choose the option for quot;Dividequot;
Click OK
Delete the 100 that you entered earlier

You may also need to adjust the formatting of your cells to show 2 decimal
places.

HTH,
Elkarquot;Donnaquot; wrote:

gt; Is there an easy way to move the decimal point other than adding a column and
gt; dividing by 100 then deleting wrong numbers?
gt;
gt; THanks,
gt; Donna