var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help with a Formula to Blank a Linked Cell
I need help in blanking out a cell filled with a linked date (1/0/1900).
I am linking cells from one spreadsheet to another and I receive this date format (1/0/1900) on all blank cells.
Here is my linked formula.
='[MS155 WO LOG.xlsx]Sheet1'!AA271
I am using Excel 2010.
Very much appreciate the help.
=IF(ISBLANK('[MS155 WO LOG.xlsx]Sheet1'!AA271),"",='[MS155 WO LOG.xlsx]Sheet1'!AA271)
I will try your suggestion deamo. Thank you so much for responding. :-)