TEXT function localization problems

A

Andikki

I have an English Excel installed on Russian Windows. I was trying to convert
a date field to text, so I found the description for the TEXT function in
Excel help. Following the description, I entered the following formula:
=TEXT(F18,"yyyy-mm-dd"). The result displayed as "yyyy-mm-dd" instead of
expected "2008-11-02". After some thinking I changed the format string to
Russian: =TEXT(F18,"гггг-мм-дд"). This time the formula worked right.

Where should I report this problem? I'm not sure if this must be called a
bug, but it definitely is not the behaviour the user would expect. Why should
functions named and described in English have Russian parameters?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with an IF Function 4
how to change language of Excell 2007 functions 1
Different Date formats in text to be recognised as date value 8
how format date with TEXT() function for international usage? 2
Formatting Dates from Text to Numbers 2
Formula to fill cells based on Date of Arrival and Date of Departure 1
Date format problems after csv import 4
Calculated Date Format in InfoPath 2003 3

Top