Excel for Mac 2011 error - "the formula contains unrecognized text" when using Excel MACRO

Hello All,

This is my first post on this forum and I'm utilizing Excel for Mac 2011. I'm the "unwanted" stepchild in my work group as most others are on PC's.

My current issue is running a MACRO that was developed on Excel 2013 (Windows) and although the MACRO runs to completion, i receive the following error for the fields in the updated spreadsheet:

"The Formula Contains Unrecognized Text" and the formulas in the boxes are:
=NUMBERVALUE($BH2)+1
=NUMBERVALUE($AX2)/1000

The cell format is set to GENERAL category.

The MACRO works fine when another Excel 2013 runs the MACRO and gets the expected results w/o error.

I'm thinking it is purely the different versions of Excel that could be the issue but wondering if there is a workaround, etc.

Thanks for your feedback.

Jon

Thanks!

That resolved the error and now actual values display.

One last question.. how can I do a bulk change of all the cell formulas values in a spreadsheet from =NUMBERVALUE($BH2)+1
to =VALUE($BH2)+1, etc?

Thanks.

Thanks you.. of, course Find & Replace duh. Thanks again!