PDA

View Full Version : Solved: Date Formatting help



KK1966
08-14-2008, 02:04 AM
Hi, all

Can u help which formulas can convert the date to MM/DD,
Original is 08142008, how can I change to 08/14

Your help I highly appreciate

Aussiebear
08-14-2008, 02:41 AM
Select the cell you want the new format to appear in. Then select Format/Cells, Custom, and create a new format mm/dd.

KK1966
08-14-2008, 02:51 AM
Dear Aussiebear
Thansk your replying & help

I might missing something as the cells( A1 = 08142008 )
how can it change to cells (B1 = 08/14 )

please advise

Thanks very much

Bob Phillips
08-14-2008, 03:13 AM
=LEFT(A1,2)&"/"&MID(A1,3,2)

KK1966
08-14-2008, 03:21 AM
Thanks very much

exactly & perfectly