date format

		Microsoft Office Forums > Microsoft Excel > Excel
date format

FAQ

Thread Tools

Display Modes

12-28-2011, 04:02 AM

gsrikanth

Windows XP date format

Office XP

Competent Performer

Join Date: Dec 2011

Posts: 133

date format

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:29 AM.