Home |
Search |
Today's Posts |
#1
|
|||
|
|||
0/01/1900
i have a VLOOKUP formula which returns a date value and i have formatted the
cells to be in date format. however when a value cannot be found (ie. returns 0) the format changes the 0 to 0/01/1900. how can i stop this? id want the cell to be blank if there is no value. appreciate your help, thanks! |