Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day - Date problem
Is your Wed-Oct-08 entry a *real* Excel date with the cell formatted to look
like that or is it just a text entry? Select one of the cells with that "date" in it and what do you see in the Formula bar... exactly what is in the cell or something that looks like a normal date? If a normal date, then (assuming the date is in A1) put =TEXT(A1,"ddd") in, say, B1. Or, again if a normal date, you could put =A1 in B1 and custom format the cell with ddd. If it is strictly text, then put =LEFT(A1,FIND("-",A1)-1) in B1. -- Rick (MVP - Excel) "JohnUK" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day - Date problem
Many thanks Rick, the TEXT ("ddd") done the trick.
Regards John "Rick Rothstein" wrote: Is your Wed-Oct-08 entry a *real* Excel date with the cell formatted to look like that or is it just a text entry? Select one of the cells with that "date" in it and what do you see in the Formula bar... exactly what is in the cell or something that looks like a normal date? If a normal date, then (assuming the date is in A1) put =TEXT(A1,"ddd") in, say, B1. Or, again if a normal date, you could put =A1 in B1 and custom format the cell with ddd. If it is strictly text, then put =LEFT(A1,FIND("-",A1)-1) in B1. -- Rick (MVP - Excel) "JohnUK" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Problem | Excel Discussion (Misc queries) | |||
Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
Us date versus EU date problem | Excel Programming | |||
Date Problem | Excel Programming |