Posted to microsoft.public.excel.misc

MICHALK

external usenet poster

Posts: 4

Changing dates

How do you change a date to text and return a string such as mmddyy to
replace 01/01/10? In other words remove the slashes but keep the same
numbers.

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
Dates changing	E[_2_]	Excel Discussion (Misc queries)	5	March 10th 09 03:21 PM
Stop UK-style dates changing to US-style dates when mailmerging.	Jean XO	Excel Discussion (Misc queries)	1	December 20th 07 12:35 PM
changing dates.	chesty	Excel Worksheet Functions	1	June 14th 06 03:04 PM
Changing Dates	JohnG	Excel Discussion (Misc queries)	1	May 17th 05 08:15 PM
Changing Dates	JohnG	Excel Discussion (Misc queries)	2	May 17th 05 06:22 PM

All times are GMT +1. The time now is 07:16 AM.

About Us

"It's about Microsoft Excel"