Posted to microsoft.public.excel.misc

Nabellfl

external usenet poster

Posts: 5

Number or text to date

I need to change 20020102 into the date format 01/02/2002. Any suggestions?

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
Date converted to Text Number	Mari	Excel Discussion (Misc queries)	6	July 29th 06 03:15 AM
Date to TEXT. NOT to sequential serial number	Gene	Excel Discussion (Misc queries)	2	May 26th 06 09:33 PM
Converting number or text to a Date Format	samhain	New Users to Excel	2	October 17th 05 02:28 PM
How do I extract a date as text not the 1900 reference number	Adam	Excel Discussion (Misc queries)	3	March 23rd 05 05:04 PM
How do I convert a number formated as a date to text in Excel?	BrotherNov	Excel Discussion (Misc queries)	5	March 2nd 05 03:51 PM

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

About Us

"It's about Microsoft Excel"