Posted to microsoft.public.excel.newusers

Totti

external usenet poster

Posts: 51

getting date in special form

Hi all i have a sheet with dates of the following form
Year Month Day
1993 May 23
1991 January 28

and i want to gather them into one row instead of three so i want
something of this format

I Wana Get
23-05-93
28-01-91

How is it possible?
Help appreciated

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
Special Date Function	Christopher D	Excel Worksheet Functions	1	September 10th 08 07:06 PM
How do you convert an uncoded date (e.g., 20080304) to a date form	tenorofchange	Excel Worksheet Functions	5	April 20th 08 02:56 PM
DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM	SSJ	New Users to Excel	3	October 27th 06 08:34 PM
Special sort for oldest and newest date	DTTODGG	Excel Discussion (Misc queries)	1	October 11th 06 05:17 PM
Copy/Paste Special (Date Format)	Saxman	Excel Discussion (Misc queries)	0	September 27th 06 02:43 PM

All times are GMT +1. The time now is 07:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us