transfer date to number
 

Hi All,

if i get an exceldate, say Fri 01 Jun 07, how can i transform it into
a number like 20070601?

I know the DAY(), MONTH() and YEAR()functions, and also the
CONCATENATE().
However, if I combine these, i get 200761

Many Thx in Advance!

AP

transfer date to number
 

On Jun 19, 8:50 am, artisdepartis wrote:
Hi All,

if i get an exceldate, say Fri 01 Jun 07, how can i transform it into
a number like 20070601?

I know the DAY(), MONTH() and YEAR()functions, and also the
CONCATENATE().
However, if I combine these, i get 200761

Many Thx in Advance!

AP

Hi there,
Try
=TEXT(A1,"YYYYMMDD")

where your date is in cell A1.

John

transfer date to number
 

Hi

Try
=TEXT(A1,"YYYYMMDD")

--
Regards

Roger Govier


"artisdepartis" wrote in message
ups.com...
Hi All,

if i get an exceldate, say Fri 01 Jun 07, how can i transform it into
a number like 20070601?

I know the DAY(), MONTH() and YEAR()functions, and also the
CONCATENATE().
However, if I combine these, i get 200761

Many Thx in Advance!

AP

transfer date to number
 

Ofc... Sometimes it can be so simple ;-)

TY!

On Jun 19, 10:17 am, JzP wrote:
On Jun 19, 8:50 am, artisdepartis wrote:

Hi All,

if i get an exceldate, say Fri 01 Jun 07, how can i transform it into
a number like 20070601?

I know the DAY(), MONTH() and YEAR()functions, and also the
CONCATENATE().
However, if I combine these, i get 200761

Many Thx in Advance!

AP

Hi there,
Try
=TEXT(A1,"YYYYMMDD")

where your date is in cell A1.

John

transfer date to number
 

Ofc... Sometimes it can be so simple ;-)

Also to you: TY!

On Jun 19, 10:17 am, "Roger Govier"
wrote:
Hi

Try
=TEXT(A1,"YYYYMMDD")

--
Regards

Roger Govier

"artisdepartis" wrote in message

ups.com...



Hi All,

if i get an exceldate, say Fri 01 Jun 07, how can i transform it into
a number like 20070601?

I know the DAY(), MONTH() and YEAR()functions, and also the
CONCATENATE().
However, if I combine these, i get 200761

Many Thx in Advance!

AP- Hide quoted text -

- Show quoted text -