Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display substitution?
I have a large spreadsheet which references cells from other spreadsheets.
There are hundreds of dates on the spreadsheet that are reported as 0-Jan-1900 because they are superseded or unused in the individual sheets. Is there a way in which I can insert a command to display nothing if date=0-Jan-1900, so that only relevant material is presented? Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than i substitution | Excel Discussion (Misc queries) | |||
Substitution of words | Excel Discussion (Misc queries) | |||
Substitution | Excel Discussion (Misc queries) | |||
substitution | Excel Discussion (Misc queries) | |||
Substitution | Excel Discussion (Misc queries) |