Remove decimal from variable length numbers

[renigar]

I need to remove the decimals from a column of numbers and retain all the digits.
Example:

123.45 = 12345
1188.00 = 118800
25.60 = 2560

I've tried find (.) and replace (). It removes the decimal but drops the zeros. I've seen an array formula that works on a fixed number of digits. Using that I think I can do it with a lengthy nested If Then statement on the sheet, but I'm hoping there is a clean reliable way to do it in VBA as part of a macro I'm already running.

Thanks,
renigar

 

[macropod]

Why not simply multiply all the values by 100? to do this, type 100 into an unused cell. Copy the cell. Select the range you want to modify. Choose Edit|Paste Special > Values > Multiply > OK.

Cheers
Paul Edstein
[MS MVP - Word]

 

[renigar]

Then format the numbers for no decimals. Way to easy. Thanks macropod.