A1=2/29/08,B1=ABC.=A1&B1.resulting in 39507abcab.how to get o/p as 2/29/2008abc in excel
K kingkhan Feb 29, 2008 #1 A1=2/29/08,B1=ABC.=A1&B1.resulting in 39507abcab.how to get o/p as 2/29/2008abc in excel
R Ron Coderre Feb 29, 2008 #2 Try this: =TEXT(A1,"M/D/YYYY")&B1 Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP)
Try this: =TEXT(A1,"M/D/YYYY")&B1 Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP)
K kingkhan Feb 29, 2008 #3 Try this: =TEXT(A1,"M/D/YYYY")&B1 Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) - Show quoted text - Click to expand... THANKS IT WORKED OUT
Try this: =TEXT(A1,"M/D/YYYY")&B1 Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) - Show quoted text - Click to expand... THANKS IT WORKED OUT
