Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to date value
I have a number which was inputted as a date but came out as a number
(1080022) I need to convert back to a date but can't figure out how to change it ( changing the format does not work). Please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to date value
what date would you like it to be?
Mike "saz2369" wrote: I have a number which was inputted as a date but came out as a number (1080022) I need to convert back to a date but can't figure out how to change it ( changing the format does not work). Please help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to date value
What date is it supposed to be?
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "saz2369" wrote: I have a number which was inputted as a date but came out as a number (1080022) I need to convert back to a date but can't figure out how to change it ( changing the format does not work). Please help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to date value
Hi Mike
I don't know what it was originally someone filled in the dates and sent it to me without realising it was not a date "Mike H" wrote: what date would you like it to be? Mike "saz2369" wrote: I have a number which was inputted as a date but came out as a number (1080022) I need to convert back to a date but can't figure out how to change it ( changing the format does not work). Please help |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to date value
Hi,
I'm afraid then there's little that can be done. If you look at the number you posted it doesn't remotely resemble a date. Post again when you have one of these numbers and you know what the date is supposed to be. Mike "saz2369" wrote: Hi Mike I don't know what it was originally someone filled in the dates and sent it to me without realising it was not a date "Mike H" wrote: what date would you like it to be? Mike "saz2369" wrote: I have a number which was inputted as a date but came out as a number (1080022) I need to convert back to a date but can't figure out how to change it ( changing the format does not work). Please help |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to date value
Unless there was some type of custom format that adds digits to the number
(say, a format of: #"22" leaving us to conclude the date entered is 10800, aka 10/8/2000) the number is meaningless as far as a date is concerned. Is there any way you could get in touch with the original author and ask them what they meant to put in there? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "saz2369" wrote: Hi Mike I don't know what it was originally someone filled in the dates and sent it to me without realising it was not a date "Mike H" wrote: what date would you like it to be? Mike "saz2369" wrote: I have a number which was inputted as a date but came out as a number (1080022) I need to convert back to a date but can't figure out how to change it ( changing the format does not work). Please help |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to date value
After formatting to date hit F2 and enter.
you will get this date: 12/29/4856 "saz2369" wrote in message ... I have a number which was inputted as a date but came out as a number (1080022) I need to convert back to a date but can't figure out how to change it ( changing the format does not work). Please help |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to date value
When you look to see what format it is in it is set at custom '0000000'
"Luke M" wrote: Unless there was some type of custom format that adds digits to the number (say, a format of: #"22" leaving us to conclude the date entered is 10800, aka 10/8/2000) the number is meaningless as far as a date is concerned. Is there any way you could get in touch with the original author and ask them what they meant to put in there? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "saz2369" wrote: Hi Mike I don't know what it was originally someone filled in the dates and sent it to me without realising it was not a date "Mike H" wrote: what date would you like it to be? Mike "saz2369" wrote: I have a number which was inputted as a date but came out as a number (1080022) I need to convert back to a date but can't figure out how to change it ( changing the format does not work). Please help |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to date value
Then I'm afraid as Mike said, there's little that can be done. You'll need to
contact the person and find out what their original date/data was. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "saz2369" wrote: When you look to see what format it is in it is set at custom '0000000' "Luke M" wrote: Unless there was some type of custom format that adds digits to the number (say, a format of: #"22" leaving us to conclude the date entered is 10800, aka 10/8/2000) the number is meaningless as far as a date is concerned. Is there any way you could get in touch with the original author and ask them what they meant to put in there? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "saz2369" wrote: Hi Mike I don't know what it was originally someone filled in the dates and sent it to me without realising it was not a date "Mike H" wrote: what date would you like it to be? Mike "saz2369" wrote: I have a number which was inputted as a date but came out as a number (1080022) I need to convert back to a date but can't figure out how to change it ( changing the format does not work). Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert number to date | Excel Discussion (Misc queries) | |||
how do you convert a number into a date | Excel Worksheet Functions | |||
Convert number to date | Excel Discussion (Misc queries) | |||
Convert Date to number? | Excel Worksheet Functions | |||
How do I convert Date serial number to date | Excel Worksheet Functions |