| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to specific the cell format?
Refering to the post in general question
Does anyone know how to do it in excel? In cell A1, if text within this cell is "Daily", then the cell B1 will show the date in this format "18-Jan". If cell A1, if text within this cell is "Monthly", then teh cell B1 will show the date in this format "Jan-07" Does anyone have any suggestion? Thank you for any suggestion Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to specific the cell format? | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Format of a cell | Excel Discussion (Misc queries) | |||
| Format cell to accept only specific character-reject others | Excel Discussion (Misc queries) | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Threaded Mode
