Posted to microsoft.public.excel.programming

Michael Koerner Michael Koerner is offline

external usenet poster

Posts: 164

Date to Text conversion

I have a sheet with a two columns containing dates. Sometimes it is the full
date as an example 25-Jul-1936, or Jul-1936 or 1936 I would like to be able
to convert that to text and maintain the same face value. Is that possible
with some sort of macro?

--

Regards
Michael Koerner

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
Text To Date Conversion	John Calder	New Users to Excel	2	March 9th 10 10:49 PM
Date to text conversion	Toke	Excel Discussion (Misc queries)	1	August 22nd 08 10:44 AM
Date to text conversion	ginnyst	Excel Discussion (Misc queries)	4	December 7th 07 03:32 PM
text to date conversion	samuel	Excel Worksheet Functions	3	August 17th 07 02:23 AM
Text Date Conversion	CPodd	Excel Discussion (Misc queries)	9	May 9th 07 04:39 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us