OK, sent you an email.

--
Biff
Microsoft Excel MVP


"Joe User" <joeu2004 wrote in message
...
Off topic....

"T. Valko" wrote:
I made a reply to you in that thread about random non-repeating numbers
but for whatever reason it
didn't get posted.

Tried to email you, but it got bounced. I cannot find the right email
address for you.

If you wish, send me the original message that you could not post.
Right-click Forward As Attachment. Send to joeu2004 "at" hotmail.com. I
try to root cause the problem.


----- original message -----

"T. Valko" wrote in message
...
Off topic...

I made a reply to you in that thread about random non-repeating numbers
but for whatever reason it didn't get posted. So I tried posting it as a
reply to my own reply but that didn't work either. It didn't contain any
references to "X" or "Y" or "Z" either! It hasn't shown up at any of the
usual places: OE as a newsreader, the MS discussion groups website or
even Google Groups.

I don't want to hijack this thread so I guess I'll just wait for the
topic to come up again.

--
Biff
Microsoft Excel MVP


"Joe User" <joeu2004 wrote in message
...
"Holly" wrote:
Is there a formula to convert the serial number 40899
above back to 12/22/2011?

It would help to know the context and the purpose.

If 40899 is the value of an Excel cell, you can simply change the format
to
Date or some Custom date format.

But note that that only changes the appearance, not the value. That is
usually what we want. But if you want text in the form of a date, if
40899
is in A1, then in B1, enter the formula =TEXT(A1,"mm/dd/yyyy") or
whatever
date format you want. Then copy B1, and paste-special-value into A1.
You
can then delete B1.

There are similar things to do in VB. If that is your context, post a
response and we can provide details.