Posted to microsoft.public.excel.misc

womit

external usenet poster

Posts: 1

number to date format

how do convert a cell with 8 numbers 19680422 into the date format 4/22/1968 ?

Reply With Quote

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
Number format to date	Maxfli	Excel Discussion (Misc queries)	4	July 25th 07 11:38 PM
How do you format a number into a date?	Kim	Excel Discussion (Misc queries)	6	September 12th 06 03:30 PM
convert number to date format	Lesley	Excel Discussion (Misc queries)	4	July 12th 06 09:17 PM
* next to date format in Formatcells Number tab	Marco18+	Excel Discussion (Misc queries)	6	April 5th 06 08:40 PM
Excel: I enter date and format for date, but shows as number	spohar	Excel Discussion (Misc queries)	2	March 10th 06 08:40 PM

All times are GMT +1. The time now is 07:05 PM.

About Us

"It's about Microsoft Excel"