excel dates tip

  robert01 14:01 07 Oct 10
Locked

Can anyone let me know the formula for coverting a date held in excel as yyyymmdd into dd/mm/yyyy.

Many thanks

  VoG II 14:20 07 Oct 10

Assuming that is a text value try

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

where A1 holds the text date.

  robert01 14:29 07 Oct 10

perfect - you have just saved me a wasted hour

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now