Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want to put my date in with no / exp: 02021951
I would like to type in my date with out using the /
Can I do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want to put my date in with no / exp: 02021951
bequa wrote: I would like to type in my date with out using the / Can I do that? Check out Chip Pearsons pages on times and dates. http://www.cpearson.com/excel/DateTimeEntry.htm Jp |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want to put my date in with no / exp: 02021951
you can use a custom format for the cell. Right=click the cell, select
Format Cells. Under the Number tab choose Custom. You type in the format you want. mmddyyyy "bequa" wrote in message ... I would like to type in my date with out using the / Can I do that? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want to put my date in with no / exp: 02021951
On Mon, 11 Sep 2006 17:57:44 -0400, "PCLIVE" wrote:
you can use a custom format for the cell. Right=click the cell, select Format Cells. Under the Number tab choose Custom. You type in the format you want. mmddyyyy Interesting recommendation. On my system, I formatted the cell as you recommended. I then entered the OP's date 02021951. The cell now shows: 11297435 I do not think that is the expected result. What is your explanation? --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want to put my date in with no / exp: 02021951
Sorry about that. I misread the post. If the date was currently showing
with slashes "/", then you could reformat it as I suggested. It does not apply if you just want to type the numbers without slashes. However, you could use a customer format of" 00000000 That should keep the typed number unchanged and force preceeding zeros to be maintained. HTH, Paul "Ron Rosenfeld" wrote in message ... On Mon, 11 Sep 2006 17:57:44 -0400, "PCLIVE" wrote: you can use a custom format for the cell. Right=click the cell, select Format Cells. Under the Number tab choose Custom. You type in the format you want. mmddyyyy Interesting recommendation. On my system, I formatted the cell as you recommended. I then entered the OP's date 02021951. The cell now shows: 11297435 I do not think that is the expected result. What is your explanation? --ron |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want to put my date in with no / exp: 02021951
On Tue, 12 Sep 2006 09:47:33 -0400, "PCLIVE" wrote:
Sorry about that. I misread the post. If the date was currently showing with slashes "/", then you could reformat it as I suggested. It does not apply if you just want to type the numbers without slashes. However, you could use a customer format of" 00000000 That should keep the typed number unchanged and force preceeding zeros to be maintained. HTH, Paul Yes, but Excel will not interpret that value as a date. To allow both the entry method, and the date interpretation, the initial recommendation to consult Chip's web site is probably the most relevant. In general, you need a VBA event macro, or a helper column with the appropriate formula, to convert the OP's desired data entry method into an Excel recognized date. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF and Date Functions | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions |