Posted to microsoft.public.excel.misc

external usenet poster

Posts: 94

how to return a serial number to a date

Example: 40899

Is there a formula to convert the serial number 40899 above back to
12/22/2011?

Thanks, Holly

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
date to text (not serial number)	jsv	Excel Discussion (Misc queries)	5	February 11th 09 09:34 PM
how to now what date represent a serial number?	cubanoluso	Excel Worksheet Functions	4	April 25th 07 03:54 PM
convert serial number into date	santhu	Excel Discussion (Misc queries)	2	October 28th 06 10:27 AM
Serial number of Date	Gazzr	Excel Worksheet Functions	2	March 24th 06 08:59 AM
date displays as serial number	et	Excel Discussion (Misc queries)	2	April 19th 05 01:10 AM

All times are GMT +1. The time now is 02:47 AM.

About Us

"It's about Microsoft Excel"