Convert Number into date format

**Chieps** · 07-09-2013, 12:08 AM

Dear all

Could you help me please. How to generate formula When condition

Cell A1
03-Jul-12 (in formula bar: 7/3/2012)

become in Cell B1
0712.03 (in formula bar: =??????)

Please help me

Regards
Cipta

**FDibbins** · 07-09-2013, 12:13 AM

what did you do in B1 to give you that result?

Keep in mind that excel sees ALL dates as a 5 digit number, representing the number of days that have passed since 1/1/1900.
So 7/3/2012 will appear as 41093

**Chieps** · 07-09-2013, 12:42 AM

Hi
Dibins

Thanks for response. I mean that I want to use in cell A1 7/3/2012 (date format) becomes appear in cell B1 0712.03
and so on for Cell A2 3/24/2013 becomes appear in cell B2 0313.24

Could you generate formula or something trick to appear in cell B like that.

Regards
Cipta

**elayaz** · 07-09-2013, 12:48 AM

If you want the date in A1(03-Jul-12) to formatted in the pattern 0712.03 in cell B1,

then paste the below formula in B1.

=TEXT(A1,"MMYY.DD")

Please be aware the date has been converted in to text now.

**FDibbins** · 07-09-2013, 12:50 AM

Perhaps something like this?

=MONTH(A1)&YEAR(A1)&"."&TEXT(DAY(A1),"00")

**Chieps** · 07-09-2013, 01:06 AM

@Elay

thanks, your solve more precise.

@debin
Thanks for solve, for year still appear 4 digit. but no problem, appreciate for response

for all
Thanks guys

Regards
Cipta

**elayaz** · 07-09-2013, 01:41 AM

@Chieps.
You're welcome..

-----------------------------------------------------------------------------------------------
If the reply solves your problem, Don't forget to mark the thread as "Solved" (Thread Tools->Mark thread as Solved)