Remove decimals

[Matt]

I would like to change 1.53 to 153 using a formula or format change. What is
the easiest way to do this? I know of a couple ways to do it but would
involve multiple steps and am trying to avoid this if possible as I am not
the one using it.

Thanks,

Matt.

 

[RagDyeR]

Multiply by 100?

What do you consider "multiple steps"?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

I would like to change 1.53 to 153 using a formula or format change. What
is
the easiest way to do this? I know of a couple ways to do it but would
involve multiple steps and am trying to avoid this if possible as I am not
the one using it.

Thanks,

Matt.

 

[Dennis]

=1.53*100

 

[Matt]

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.

 

[RagDyeR]

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.