Text function multinational format

I

IgorM

Hi

In one of my spreadsheets I used a text function to retrieve year from a
cell. It's important to point put that I use Polish version of Excel. The
function (in my version) was as follows '=tekst(A1;"rrrr")' - value of A1 is
"2009-01-23". The format "rrrr" is an equivalent of "yyyy". I than had to
send it to someone with an English version of Excel. Unfortunately, the
displayed value was "rrrr" and not "2009". Is it possible to use this
function in both versions of Excel?

Kind regards
IgorM
 

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

Populate cell with multiple non-blank text values 4
Function Help Please 4
Text formatted for Days and Dates 12
VBA: Copy a date and paste as text 3
Hidden Formating Or Delimiters: Showing Of ? 2
Differences Between Two Spreadsheets ? 2
Duff Date Text 3
TEXT function international dates 4

Top