Convert number to date value

[saz2369]

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

 

[Mike H]

what date would you like it to be?

Mike

 

[Luke M]

What date is it supposed to be?

 

[saz2369]

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]

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

 

[Luke M]

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?

 

[Learning VBA]

After formatting to date hit F2 and enter.
you will get this date:
12/29/4856

 

[saz2369]

When you look to see what format it is in it is set at custom '0000000'

 

[Luke M]

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.