Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Format
The digits typed do not match the output, I wonder why.
I also tried to type 000000 and that defaulted to Jan1 1900. then I input 010101 which results into 8/27/27 , for 8/27/1927. this really baffles me, as I tried to Clear All to no avail. thanks for your help |
#2
|
|||
|
|||
You have to put in a date separator to get dates, such as
01/01/01 or 15/01/2004 -- HTH Bob Phillips "itqueen" wrote in message ... The digits typed do not match the output, I wonder why. I also tried to type 000000 and that defaulted to Jan1 1900. then I input 010101 which results into 8/27/27 , for 8/27/1927. this really baffles me, as I tried to Clear All to no avail. thanks for your help |
#3
|
|||
|
|||
dah, thanks, Bob. yup, the separators...that about doubles the time during
huge amount of data entries. So I did the right thing ... created a special format "00 00 00" , with only 6 digits needed for input. "Bob Phillips" wrote: You have to put in a date separator to get dates, such as 01/01/01 or 15/01/2004 -- HTH Bob Phillips "itqueen" wrote in message ... The digits typed do not match the output, I wonder why. I also tried to type 000000 and that defaulted to Jan1 1900. then I input 010101 which results into 8/27/27 , for 8/27/1927. this really baffles me, as I tried to Clear All to no avail. thanks for your help |
#4
|
|||
|
|||
If you have a lot of dates to input, you could take a look at
http://xldynamic.com/source/xld.QDEDownload.html, might be just what you need. -- HTH Bob Phillips "itqueencanada" wrote in message ... dah, thanks, Bob. yup, the separators...that about doubles the time during huge amount of data entries. So I did the right thing ... created a special format "00 00 00" , with only 6 digits needed for input. "Bob Phillips" wrote: You have to put in a date separator to get dates, such as 01/01/01 or 15/01/2004 -- HTH Bob Phillips "itqueen" wrote in message ... The digits typed do not match the output, I wonder why. I also tried to type 000000 and that defaulted to Jan1 1900. then I input 010101 which results into 8/27/27 , for 8/27/1927. this really baffles me, as I tried to Clear All to no avail. thanks for your help |
#5
|
|||
|
|||
great link, thanx
"Bob Phillips" wrote: If you have a lot of dates to input, you could take a look at http://xldynamic.com/source/xld.QDEDownload.html, might be just what you need. -- HTH Bob Phillips "itqueencanada" wrote in message ... dah, thanks, Bob. yup, the separators...that about doubles the time during huge amount of data entries. So I did the right thing ... created a special format "00 00 00" , with only 6 digits needed for input. "Bob Phillips" wrote: You have to put in a date separator to get dates, such as 01/01/01 or 15/01/2004 -- HTH Bob Phillips "itqueen" wrote in message ... The digits typed do not match the output, I wonder why. I also tried to type 000000 and that defaulted to Jan1 1900. then I input 010101 which results into 8/27/27 , for 8/27/1927. this really baffles me, as I tried to Clear All to no avail. thanks for your help |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format
So aside from the QDE tool, Excel(2000) does not have an input mask for dates
like it has for SS# or zip codes. My data is very simple and do not anticipate calculating on the dates. "Bob Phillips" wrote: You have to put in a date separator to get dates, such as 01/01/01 or 15/01/2004 -- HTH Bob Phillips "itqueen" wrote in message ... The digits typed do not match the output, I wonder why. I also tried to type 000000 and that defaulted to Jan1 1900. then I input 010101 which results into 8/27/27 , for 8/27/1927. this really baffles me, as I tried to Clear All to no avail. thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Date format collapses diagram | Excel Discussion (Misc queries) | |||
prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |