Question for VOG

  AndySD 17:27 29 Mar 2011
Locked

Hi

I have an excel document where Row A is set to Date Format and row B is set to text. Now using Concatenate I get the text with a number is there any way of getting the date with the text?

  VoG II 17:42 29 Mar 2011

Hi. Try like this

=B1&" "&TEXT(A1,"dd/mm/yyyy")

You can change "dd/mm/yyyy" to your preferred date format.

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 ?