This may be more trouble then it's worth, but if you have numerous cells, it
may be worthwhile.
If the cells you want to convert are contiguous, then forget about naming a
range.
If they're spread out, all over the sheet, create a named range.
Select all the cells involved, by holding <Ctrl> and clicking in each cell.
Then, while the cells are still selected, click in the name box and type in
a short name, such as
temp
Then <Enter>.
Now in an unused cell enter
32
and in another cell, enter
1.8
And format this last cell to the way that you wish the final appearence of
your temperatures to display.
i.e. number - 1 decimal place
Now, right click in the
32
cell and choose "Copy".
Select your temp cells.
Right click in the selection and choose "PasteSpecial".
Click "Subtract", then <OK>.
Right click in the
1.8
cell and choose "Copy".
Select the temp cells again.
Right click in the selection and choose "PasteSpecial".
Click "Divide", then <OK>.
You should now have all your temperature cells coverted, and in the desired
format.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I need to change some of the cells in an XL spreadsheet from degrees F to
degrees C. I can easily change one cell at a time, but it would be more
efficient to change multiple cells.
