Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dates
Hello Group,
I have made this custom date format for dates in excel. 0"/"00"/19"00. It allows me to enter dates without entering the '19' part of the date year. It also enters the / 's for me. However, it does not allow me to enter single digit months, which in this case is the 2 zeroes after the first "/" . I've tried it with just one zero, but that still does not work. What's up with that!?? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200510/1 |
#2
|
|||
|
|||
Dates
It may look like dates but it isn't dates in excel sense, you can make any
calculations, as an example put 101499 in A1, it will display as 10/14/1999, now in A2 put 101699, displays as 10/16/1999 now if these were dates that one could make calculations with =A2-A1 formatted as General would return 2 (for 2 days), in your case it returns 200? so you can use them as display a number that looks like a date but you can't do anything with it if you want to cut down on the usage of delimiters you can use Chip Pearson's macro http://www.cpearson.com/excel/DateTimeEntry.htm -- Regards, Peo Sjoblom (No private emails please) "eternal_cat via OfficeKB.com" <u14645@uwe wrote in message news:56188088c4c5e@uwe... Hello Group, I have made this custom date format for dates in excel. 0"/"00"/19"00. It allows me to enter dates without entering the '19' part of the date year. It also enters the / 's for me. However, it does not allow me to enter single digit months, which in this case is the 2 zeroes after the first "/" . I've tried it with just one zero, but that still does not work. What's up with that!?? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200510/1 |
#3
|
|||
|
|||
Dates
k, IT returned a date as the answer, but with the dashes around it. I also
wanted to know how to change between two conventional date formats quickly without using the mouse, cos i use two different formats yeah. ThanKs! Peo Sjoblom wrote: It may look like dates but it isn't dates in excel sense, you can make any calculations, as an example put 101499 in A1, it will display as 10/14/1999, now in A2 put 101699, displays as 10/16/1999 now if these were dates that one could make calculations with =A2-A1 formatted as General would return 2 (for 2 days), in your case it returns 200? so you can use them as display a number that looks like a date but you can't do anything with it if you want to cut down on the usage of delimiters you can use Chip Pearson's macro http://www.cpearson.com/excel/DateTimeEntry.htm Hello Group, [quoted text clipped - 7 lines] What's up with that!?? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200510/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Default Dates | Excel Discussion (Misc queries) | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel |