Posted to microsoft.public.excel.programming

Marc[_10_] Marc[_10_] is offline

external usenet poster

Posts: 2

numbers to dates

I have a column of numbers that I need to convert to dates, such as:

7252003
11152001
3312002

Some have length of 7, and some are 8. I can do this manually by
adding "0" to the 7 length numbers, then Data, Text to Columns/Date.
Is there a way to do this (faster) in a macro?

Thanks,
Marc

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
Stop dates from showing as numbers - when formated as dates	JR	Excel Discussion (Misc queries)	1	October 29th 08 04:38 PM
dates and numbers	be_mcwayne	Excel Discussion (Misc queries)	3	February 22nd 07 01:15 PM
why does dividing numbers give me dates and not numbers?	dylan	Excel Discussion (Misc queries)	1	June 21st 06 11:40 PM
Numbers To Dates	bodhisatvaofboogie	Excel Discussion (Misc queries)	13	May 22nd 06 05:31 PM
Dates to numbers	John	Excel Worksheet Functions	0	February 8th 05 11:45 AM

All times are GMT +1. The time now is 11:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us