If you have a large number of cells that you need to modify, you can enter
100
in an unused cell,
Right click in that cell and choose "Copy".
Select the cells to modify,
Right click in that selection and choose "Paste Special",
Click on "Multiply", then <OK>, then <Esc>.
If the cells you want changed will always be the same, you can simplify this
procedure slightly by assigning a name to that range of cells.
Then, just clicking that assigned name in the "Name" box will select all
those cells in a single shot.
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
AH, of course. That was an obvious solution I overlooked!
The multiple steps I was speaking of was to use text to columns to remove
the decimal than combining the two resulting columns afterwards. Also
considered writing a macro to replace the "." with ""
Thanks again.
