Question for VOG

  AndySD 17:27 29 Mar 11
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 11

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

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

The Fresh New Fonts of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced