Posted to microsoft.public.excel.programming

Stuart[_3_] Stuart[_3_] is offline

external usenet poster

Posts: 50

Change dates from dd/mm/yy to 6 digits being ddmmyy

The subject line is exactly what I need,

I do not want the dates to have any characters between them. I just
literally want six digits.

Our system cannot accept character only numberics.

If a macro could do this that would be amazing,

Let me know,

Thanks

Stuart

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
How do you change single digits to recognized double digits?	Evil with a K[_2_]	Excel Worksheet Functions	5	April 3rd 23 02:29 PM
VBA write macro change column with 3 number digits to 4 digits the	James C[_2_]	Excel Discussion (Misc queries)	3	January 25th 10 03:12 PM
how do i format date to DDMMYY	Maz	Excel Discussion (Misc queries)	2	August 23rd 07 11:07 AM
Converting Dates to 8 digits	jermsalerms	Excel Worksheet Functions	17	January 20th 06 02:00 AM
Entering dates in vba inputbox as ddmmyy. Excel returns mmddyy	pkeegs	Excel Programming	3	August 30th 05 08:57 AM

All times are GMT +1. The time now is 01:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us