Entering Decimal point in Price Range

[philmatth]

Hi,
I have a price range in the following format
<table width="64" border="0" cellpadding="0" cellspacing="0"><col style="width:48pt" width="64"> <tbody><tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt; width:48pt" width="64" align="right" height="17">37440</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" align="right" height="17">31200</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" align="right" height="17">39500</td> </tr> </tbody></table>
I need to insert a decimal poin tbefore the last two characters like this

<table width="64" border="0" cellpadding="0" cellspacing="0"><col style="width:48pt" width="64"> <tbody><tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt; width:48pt" width="64" align="right" height="17">374.40</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">312.00</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">395.00</td> </tr> </tbody></table>
I understand this is probably extremely simple for the experts but I can't think of a method of doing it

 

[mikerickson]

A formula like this should do it.
=A1/100

 

[philmatth]

Dohhh - of course!

Thank you very much and sorry to bother you!

 

[pgc01]

Hi Phil

Another option, that changes the values of the cells directly:

- write 100 in a cell and copy it
- select your cells, Paste Special->divide