Date Format (Excel 2002)

Topic

New Reply

In a database, one of my columns is in a date format (mm/dd/yy). In another worksheet I pull in this cell that contains the date by using a formula (=database!$A$2). I formatted this cell to also be a date format of mm/dd/yy and everything worked dandy as I’ve done this a million times. Next I added to the formula the following

=database!$A$2&” UPS Charges”

Now the date has translated itself into a number as opposed to the date that I need… for example, I’d like to see it read as the following:

6/21/06 UPS Charges

As usual, any help will be greatly appreciated!
Thank you!
LJM

Reply | Quote

Replies

Try

=TEXT(database!$A$2,”m/d/yy”)&” UPS Charges”)

or simply use

=database!$A$2

and set a custom format

m/d/yy” UPS Charges”

Reply | Quote

Thanks Hans!
LJM

Reply | Quote