Posted to microsoft.public.excel.programming

J.E. McGimpsey J.E. McGimpsey is offline

external usenet poster

Posts: 493

Date formating

One way:

Choose Data/Text to Columns. Click Next, Next, then select ymd from
the Date dropdown and click Finish.

In article ,
"Jason Trolian" wrote:

I have a spreadsheet that comes with the date formated
like this (yyyymmdd - 20030910) The normal format cell
function will not change that date to (mmddyy -
09/10/2003) any way I can do this?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
formating a date	Jim	Excel Discussion (Misc queries)	1	March 31st 09 06:53 PM
formating and date changes	vince	Excel Discussion (Misc queries)	0	May 22nd 08 11:11 PM
Date formating	singh	Excel Worksheet Functions	3	April 10th 08 02:51 PM
Date formating	chad	Excel Worksheet Functions	3	October 21st 06 03:31 PM
Date formating	Jake Marx	Excel Programming	0	September 10th 03 09:02 PM

All times are GMT +1. The time now is 10:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us