date format

gsrikanth · #1 12-28-2011, 04:02 AM

in the excel cell iam trying type 5-43 it is comming 15827. how i get 5-43 instead of 15837?

if i convert 15827 in custom m-yy it is going to 5-43. my question is '-' not replacing by . ? i want 5-43 to 5.43.

Catalin.B · #2 12-28-2011, 05:06 AM

Quote:

Originally Posted by gsrikanth

if i convert 15827 in custom m-yy it is going to 5-43. my question is '-' not replacing by . ? i want 5-43 to 5.43.

Why don't you use as custom format m.yy, it will show 5.43...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to custom Date Picker CC format with Ordinal and superscript it!	areriff	Word VBA	5	08-21-2022 04:28 PM
Mail merge will not format date field generated by Excel IF statement	borntorun75	Mail Merge	3	12-16-2011 06:28 AM
new appointment date always reverts back to today's date	msills	Outlook	0	08-24-2007 08:57 AM
Date format always interpreted as a formula	Butch Jackman	Excel	1	02-14-2006 11:27 AM
Imported message date change to today's date	promark	Outlook	1	12-23-2005 07:21 AM