DATE

  • Thread starter Thread starter JW
  • Start date Start date
J

JW

I SURE COULD USE SOME HELP WITH CONCATENATING A DATE AND
TEXT. A DATE (DATE FORMAT = dd-mmm-yyyy) IS LOCATED IN
ONE CELL ON SHEET1 AND I NEED TO INCLUDE IT IN A
CONCATENATED FORMULA ON SHEET2 (basic example ="date
="&sheet1!A1). UNFORTUNATELY, THE UNDERLINING SERIAL
NUMBER (DATE = 38034) IS RETURNED VERSUS THE FORMATED
DATE (DATE = 17-Feb-04). ANY IDEAS HOW I CAN CORRECT
THIS? THANKS IN ADVANCE FOR YOUR TIME.
 
Hi
try
="Date: " & TEXT('sheet1'!A1,"DD-MM-YYYY")

P.S.: please turn off your CAPS LOCK as your post is quite difficult to
read and all upper case is considered as shouting in NG
 
Back
Top