| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=month formula no working
I import text in to excel and in one cell its listed a such:
' 11-JAN-07 Now I have tried clearing the format and changing the cell to a date, but the =month formula does not work. Do I did the following: Cell A1 (' 11-JAN-07) Cell B1 =A1 Cell C2 =month Now I got that to work once and I have not been able to make it work again. Help!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Is it possible? | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Working Hours (formula & graph) - any elegant solution? | Excel Worksheet Functions | |||
| Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
