Posted to microsoft.public.excel.worksheet.functions

Carl

external usenet poster

Posts: 361

Date Format Question

I have text vlaues that are like this:

Aug1
Aug10
Aug11
Aug14
Aug15
Aug16
Aug17
Aug18

Is there a way to convert these to actual dates ?

Thank you in advance.

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
Mileage Claim Formula	johndavies	New Users to Excel	4	August 14th 06 09:24 AM
Date Format question	Aaron	Excel Discussion (Misc queries)	3	April 5th 06 01:51 PM
Date format with day of week and date	Kathy	Excel Discussion (Misc queries)	4	October 25th 05 04:38 AM
MS Query Date Format	scos00	Excel Discussion (Misc queries)	0	October 21st 05 04:58 PM
Date Format Question	Josh O.	Excel Discussion (Misc queries)	1	February 10th 05 09:45 PM

All times are GMT +1. The time now is 05:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us