=CONCATENATE and Excel 97

  ThePharcyde007 15:38 27 Sep 2004

Going mad as per usual!! Trying to =CONCATENATE a date and a %. But when I select the date to =CONCATENATE it is formating it into a number format. Is there anyway to stop this as putting a "'" infront of the date works, but I am trying to do a macro and the dates are never the same.


  pc moron 16:17 27 Sep 2004

Convert the date and percentage to text first, ie:

=CONCATENATE(TEXT(A1,"dd/mm/yy")," ",TEXT(B1,"0.00%"))

If the date is in A1 and the percentage is in B1, it returns the result 27/09/04 10.00%.

  ThePharcyde007 16:27 27 Sep 2004

Cheers mate sorted :-)

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

InVision Studio takes on Adobe XD and Sketch

Camera tips to take better iPhone photos

Comment transformer un iPhone en borne Wi-Fi ?