Convert Date to Text

[hcabs99]

Hi

I need to convert some dates & times into text, but they need to retain their characteristics
i.e. dd.mm.yyyy & hh;mm


Whenever i convert them , they are changed to the decimal value


Any ideas please?

Cheers

 

[Andrew Poulsom]

Use the TEXT function:

=TEXT(A1,"dd.mm.yyyy")

=TEXT(A1,"hh:mm")

 

[brans1982]

You can use the TEXT functio.

So if the date value you want to convert is in cell A1 then you formula would be...

=TEXT(A1,"dd.mmm.yyyy hh;mm")

 

[hcabs99]

Use the TEXT function:

=TEXT(A1,"dd.mm.yyyy")

=TEXT(A1,"hh:mm")

Spot on, thanks guys!