| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change number to date
How to change the number 1122008 to 1/12/2008?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change number to date
Probably the best is:
=date(mod(a1,10000),mod(int(a1/10000),2),day(int(a1/1000000))) This will handle the case where you have two digit dates. Regards Fred "Happy One" <Happy wrote in message ... How to change the number 1122008 to 1/12/2008? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change number to date
=DATE(RIGHT(A2,4),MID(A2,LEN(A2)-5,2),LEFT(A2,LEN(A2)-6))
-- David Biddulph "Happy One" <Happy wrote in message ... How to change the number 1122008 to 1/12/2008? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change number to date
This worked for me with my USA date settings (mdy):
=--TEXT(A1,"00\/00\/0000") and formatted as a date Happy One wrote: How to change the number 1122008 to 1/12/2008? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change number to date
Yes, it works.
Thank you, "Dave Peterson" wrote: This worked for me with my USA date settings (mdy): =--TEXT(A1,"00\/00\/0000") and formatted as a date Happy One wrote: How to change the number 1122008 to 1/12/2008? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i change the default from a date to a number? | Excel Discussion (Misc queries) | |||
| Change date to number | Excel Worksheet Functions | |||
| Formula to change number into date | Excel Discussion (Misc queries) | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| How do you change the date to a Number | Excel Discussion (Misc queries) | |||
Linear Mode
