Date in Concatenate Formula In Excel 97

Posted by Rich A on May 09, 2001 10:44 AM

I need to concatenate a date with some other data in a spreadsheet. When I use the date from a column, the date is in format mm/dd/yy, and when I put it into the concatenate formula, it is in (I believe) Julian(?) Julienne (?) format. How do I convert this to the same format (mm/dd/yy) without converting it to Julian?
Any ideas? I know I can create a macro that will put an apostrophe in front of the correctly formatted date, which will convert it to text, but I was wondering if there's an easier way?

Posted by Mark W. on May 09, 2001 10:49 AM

=TEXT(A1,"MM/DD/YY") where A1 contains your date value.
By the way, it wasn't Julian it was Excel's internal
date value.

Posted by Dave Hawley on May 09, 2001 10:51 AM

Hi rich

Use:

=F10&" " & TEXT(G10,"mm/dd/yyyy")

Where G10 contains your date.

Dave
OzGrid Business Applications