Mac

Not on my machine (International English)

=TEXT(Value,Format_Text)

works fine.

Didn't know that regional settings affected formulas? Anyone?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"Mac B" <Mac wrote in message
...
Excel in Office 2003
All the samples in Excel help are wrong

example : TEXT(value,format_text) that does not work !

should be: TEXT(value;format_text)

this happens through all help examples,
could somebody tell me who got fired for such mistakes?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc