Bahttext in Mac OS X Excel?

[Vynn]

Hi all, I tried searching but I don't seemed to find any information about bahttext in OS X Excel. Whenever i use this formula in my Mac, the result came out "#NAME?"

My question is, is this formula supported in Mac..?

[DonkeyOte]

Which Mac version ?

I think it was introduced w/2002 (Windows -so 2004 would I guess be first Mac version in which it's supported)
On line MS doc. would imply it can be used on Mac

edit: that said this implies otherwise

[Vynn]

Excel for Windows uses the BAHTTEXT function to convert a number to Thai text and add a suffix of "Baht." Excel for Mac can open and display sheets that are created in Excel for Windows and that contain BAHTTEXT. But if you recalculate such a sheet in Excel for Mac, any cells that contain BAHTTEXT display the #NAME! error value. To prevent Excel from recalculating a cell that contains BAHTTEXT, copy the cell and then paste it back into place as a value by using the Paste Special command on the Edit menu. After you do this, the cell does not recalculate with the rest of the workbook.

I don't quite understand the meaning. Can you simplify it for me? Sorry, my english isn't that good.

[DonkeyOte]

It basically says you can not conduct BAHTTEXT calculations on a Mac.

If you open a file with BAHTTEXT results already in it (ie from a Windows machine) - the Mac can display the values but should you recalculate you will get Errors (per the first point)
(in these instances you should copy the BAHTTEXT results and paste the values over the formulae)

[Vynn]

Ok. In simple, I can't use BAHTTEXT in Mac..?

[DonkeyOte]

I don't have a Mac to be sure but it seems not...

[Vynn]

Ok. Thanks for the infomation.