converting a date into a string

[Jean-Paul Leburton]

[This message was posted to microsoft.public.excel.worksheet.functions]
I would like to transform a date into a string to concatenate it with
other strings in a field. Many thanks

--
Jean-Paul Leburton
Loncin, Belgique
http://users.skynet.be/jpleburton/

[Arvi Laanemets]

Hi

P.e.
=TEXT(YourDate,"dd mmmm yyyy")

Arvi Laanemets

"Jean-Paul Leburton" <jean.paul...@skynet.be> wrote in message
news:MPG.19046223f...@news.skynet.be...

[Mike]

What kind of the string you want? Show several samples.

--
Mike

Ref to "Jean-Paul Leburton" <jean.paul...@skynet.be> wrote in message news:MPG.19046223f...@news.skynet.be...

[Norman Harker]

Hi Jean-Paul

Try and see the principles in the following:

A1 TODAY()
A2 The date today is

A3

=A2 & " " & TEXT(A1,"dd-mmm-yyyy")

The TEXT function takes a number as it's first argument and returns text formatted according to the format string enclosed in double
quotation marks as the second argument.

I'm afraid that you may have to translate my function names above but in French TODAY is AUJOURDHUI and TEXT is TEXTE.

Jan Karel Pieterse has a downloadable translation file available free from:

http://www.bmsltd.co.uk/MVP/

It's called XLMenuFunDict.zip

--

Regards
Norman Harker
Sydney, Australia
Excel & Word format Function Lists free to good homes by direct request to:
njha...@optusnet.com.au

"Jean-Paul Leburton" <jean.paul...@skynet.be> wrote in message news:MPG.19046223f...@news.skynet.be...

[Jean-Paul Leburton]

[This followup was posted to microsoft.public.excel.worksheet.functions
and a copy was sent to the cited author.]

In article <emBn1HmA...@TK2MSFTNGP12.phx.gbl>,
njha...@optusnet.com.au says...

> Hi Jean-Paul
>
> Try and see the principles in the following:
>
> A1 TODAY()
> A2 The date today is
>
> A3
>
> =A2 & " " & TEXT(A1,"dd-mmm-yyyy")
>
> The TEXT function takes a number as it's first argument and returns text formatted according to the format string enclosed in double
> quotation marks as the second argument.
>
> I'm afraid that you may have to translate my function names above but in French TODAY is AUJOURDHUI and TEXT is TEXTE.
>
> Jan Karel Pieterse has a downloadable translation file available free from:
>
> http://www.bmsltd.co.uk/MVP/
>
> It's called XLMenuFunDict.zip
>
>
>

No kidding about the translation, many thanks to those who responded to
my request ! I also discovered that when someone creates a worksheet
with functions in english, in the USA for instance or in the UK , or
anyone using Excel in english, the functions names appear automatically
in FRENCH when i do open it here in Belgium (the surprise package of
Europe)

[Norman Harker]

Hi Jean-Paul!

I understand the automatic translation of workbooks prepared on English Language versions.

Out of interest, what happens when you use the English name for the function in your "Local" version.

I visited your country last year. Great time in Antwerp! Beautiful city. Pity about the weather.

--

Regards
Norman Harker
Sydney, Australia
Excel & Word format Function Lists free to good homes by direct request to:
njha...@optusnet.com.au

"Jean-Paul Leburton" <jean.paul...@skynet.be> wrote in message news:MPG.1904a5f2d...@news.skynet.be...

[Anders S]

Norman,

English function names are not recognised by localised versions of Excel.

With my Swedish Excel I get a #NAME error if I enter, for example, =TODAY()
on a worksheet, which means that formulas that I pick up in the newsgroups
can not directly be used.

To translate formulas between English and Swedish, I use the Immediate
Window in VBA like in
Range("A1").Formula = "=TODAY()"
and
?Range("A1").Formula
which works unless there are quotes in the formula like in
range("A1").Formula = "=A2 & " " & TEXT(A1,"dd-mmm-yyyy")"
which renders an error. In that case, double quotes must be inserted lik in
range("A1").Formula ="=A2 & "" "" & TEXT(A1,""dd-mmm-yyyy"")"

Best regards
Anders Silvén

"Norman Harker" <njha...@optusnet.com.au> skrev i meddelandet
news:#BN6jgnA...@TK2MSFTNGP10.phx.gbl...

[Norman Harker]

Thanks Anders!

I suspected as much as I can't use non-English names with an English Version. As I'm linguistically challenged you are streets ahead
in being able to read newsgroups in more than one language. But it is useful to know how to resolve translation issues.

--

Regards
Norman Harker
Sydney, Australia
Excel & Word format Function Lists free to good homes by direct request to:
njha...@optusnet.com.au

"Anders S" <anders...@hotmailxyz.com> wrote in message news:OtHV#ypADH...@TK2MSFTNGP11.phx.gbl...

[Jean-Paul Leburton]

[This followup was posted to microsoft.public.excel.worksheet.functions
and a copy was sent to the cited author.]

In article <#BN6jgnA...@TK2MSFTNGP10.phx.gbl>,
njha...@optusnet.com.au says...

> Hi Jean-Paul!
>
> I understand the automatic translation of workbooks prepared on English Language versions.
>
> Out of interest, what happens when you use the English name for the function in your "Local" version.
>
> I visited your country last year. Great time in Antwerp! Beautiful city. Pity about the weather.
>
>

We have an exciting spring season, quite dry ....

[Jean-Paul Leburton]

[This followup was posted to microsoft.public.excel.worksheet.functions
and a copy was sent to the cited author.]

In article <OtHV#ypADH...@TK2MSFTNGP11.phx.gbl>,
anders...@hotmailxyz.com says...

> Norman,
>
> English function names are not recognised by localised versions of Excel.
>

We speak of two different things. Indeed, entering the functions in a
language which is not the one of the version you do use is not working.
But if you have an italian friend, who entered the functions in italian,
then if you open the file in the english version , the functions names
are TRANSLATED !