Posted to microsoft.public.excel.misc

Tom

external usenet poster

Posts: 19

Date conversion

I'm sure this question has been asked before.
How to convert the date expressed as "20061215" to read as 15/12/2006?
Thanks for your help.

Tom

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 formulas	DRondeau	Excel Discussion (Misc queries)	7	September 6th 06 09:53 PM
Date Conversion	MIchel Khennafi	Excel Worksheet Functions	3	July 20th 06 05:56 PM
date conversion after pasting	DC Gringo	Excel Worksheet Functions	2	February 16th 06 06:05 PM
Date Conversion	jdmcleod	Excel Discussion (Misc queries)	2	March 20th 05 12:12 AM
unwanted number to date conversion while pasting data from web	Jacek	Excel Worksheet Functions	1	February 24th 05 02:59 PM

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

About Us

"It's about Microsoft Excel"