| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format Cells to show different values
I currently have this format for my cells in a list - "In "#,##0"
Day(s)";#,##0" Day(s) ago" I would like to be able to show the text "Today" if the cell value is zero. Also, if possible, I'd like to get rid of the "(s)" ie if the value is more than 1 or less than -1 it should say "Days" and say "Day" if equal to 1 or -1. Also, can someone point me in the direction of a help file/website for advanced formatting like this.. Thanks Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| want format cells alignment not format cells font style | Excel Discussion (Misc queries) | |||
| How do I hide zero values but keep currency format in P.O. form? | New Users to Excel | |||
| Show cells have been read - linked | Excel Discussion (Misc queries) | |||
| How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
Threaded Mode
