Posted to microsoft.public.excel.misc

Morgs

external usenet poster

Posts: 4

Handling date formats...

SO I know all about using the custom option in format cells, but this only
works if I have something in a format excel recognizes, right?

I have lists of dates printed out in yyyymmdd format, and I want that to be
converted to dd/mm/yyyy. How do I do this?

Thanks,
Morgs

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 Formats	Denise	Excel Discussion (Misc queries)	4	April 4th 07 08:41 PM
Date formats	Craig	Excel Discussion (Misc queries)	2	January 10th 07 10:30 PM
Date Formats	Greenback	Excel Discussion (Misc queries)	5	August 15th 06 08:32 AM
date formats	Matt	Excel Discussion (Misc queries)	2	May 17th 06 07:52 AM
Date formats	JR	Excel Discussion (Misc queries)	1	June 1st 05 12:04 AM

All times are GMT +1. The time now is 10:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us