Edit cell referenced formula to remove multiplication

[KatDaw]

Hi,
I'm working with a file that has a lot of cell references to other external worksheets. Most of the formulas contain a *1000000 at the end reflect the result in $millions.

I need to remove the *1000000 in the formula, while preserving the cell reference.

Find and replace doesn't work as it removes the original cell reference portion of the formula.

I'm open to a VBA solution as this multiplication issue appears in a lot of the worksheets in this workbook.
Thanks in advance!

 

[KatDaw]

Here is an example of the formula problem:

=('A) Summary PRRT'!BH23)*1000000

 

[bosco_yip]

Select column of formula cells >> Data >> Text to Columns >> Choose " Delimited" >> Next >> Next >> In step 3 of 3, choose "Text" >> Finish

Then,

>> Ctrl+H >> in the "Find and Replace" dialogue :
>> "Find what", enter: ~*1000000
>> "Replace with" : (keep empty)
>> Click "Replace All"
>> Close

Regards
Bosco