improve help samples in excel 2003

[Guest]

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/com...b-750c1144d4ad&dg=microsoft.public.excel.misc

 

[Nick Hodge]

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

(e-mail address removed)
www.nickhodge.co.uk

 

[Roger Govier]

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.

 

[Nick Hodge]

Roger

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

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

(e-mail address removed)
www.nickhodge.co.uk