excel dates tip

  robert01 14:01 07 Oct 2010
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 2010

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 2010

perfect - you have just saved me a wasted hour

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?