Posted to microsoft.public.excel.programming

JohnUK

external usenet poster

Posts: 173

Day - Date problem

Hi, I have a list of dates (approx 500 rows) on an excel spreadsheet that I
want to convert to values, how can I do this through VBA?
Date format (if it makes a difference) is for example Wed-Oct-08 and what I
want is the cell next to it to show as Wed in text (not a number, then
formatted)
Many thanks for help

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
Date Problem	Nick C	Excel Discussion (Misc queries)	4	March 4th 09 04:15 PM
Exel increment date problem wrt todays date.	[email protected]	Excel Worksheet Functions	1	November 11th 07 06:58 PM
Date Formula Problem - Leave date blank if Null	Gayla	Excel Worksheet Functions	5	April 24th 07 09:42 PM
Us date versus EU date problem	Jan T.	Excel Programming	7	October 2nd 06 07:06 PM
Date Problem	hon123456	Excel Programming	1	September 18th 06 08:11 AM

All times are GMT +1. The time now is 10:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us