Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell Question
I have data Imported into cells from another program. The data is a date,
and it comes into the cell as follows: April, 2006 = 406 December, 2006 = 1206 etc, etc... Now, I want to format the cells such that they change to Apr-06 Dec-06 I have been messing around trying to figure out a custom format, and have had no luck. What am I missing? Ultimately I'll incorporate this into a macro, SO, if there are some CODE solutions, bring em on. THANKS!!!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |