#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Why don't you use as custom format m.yy, it will show 5.43...
|
Thread Tools | |
Display Modes | |
|
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 |