Excel Universal DDE and floating point error in Multicharts

I came accross an error if you are using a DDE server to your excel spreadsheets, which can cause MC to have a floating point error.

I have found a relatively simple fix, which can be done in EXCEL(not multicharts). You can try this in your cell for example:

=IF(ISNUMBER(L37),L37,0)

The ISNUMBER function will check to make sure that the cell contains a number.

You'll get a floating point error in MC if the cell is a word error, such as "NAME?"

Thanks for the tip, it may be useful for someone, but it isn't in my opinion much related to MultiCharts data.
It's a generic data problem - if there's a word entry in a file containing quotes data, that file is pretty much broken, and this won't occur in something like a data stream from a data vendor.