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

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

Hi Nick

Yes this is the case.
I have often seen cases where the OP says a solution posted by one of us
using either US or UK settings does not work for them.
The semicolon versus the comma as a separator is usually the "culprit".
Amending the formulae to use whatever their local regional separator is
inevitable solves the problem.
--
Regards

Roger Govier


"Nick Hodge" wrote in message
...
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

Roger

Shame that doesn't extend to the USCentric VBA, still...thanks for the
note...logged

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

HIS
www.nickhodge.co.uk

"Roger Govier" wrote in message
...
Hi Nick

Yes this is the case.
I have often seen cases where the OP says a solution posted by one of us
using either US or UK settings does not work for them.
The semicolon versus the comma as a separator is usually the "culprit".
Amending the formulae to use whatever their local regional separator is
inevitable solves the problem.
--
Regards

Roger Govier


"Nick Hodge" wrote in message
...
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