linking data 0

[JakeAy]

Hi all you lovely people in ExcelForumLand,

When I link data in my spreadsheet from another file (using =), any cells in the source spreadsheet which are empty get translated to the destination as 0. Is there any way around this? For presentation purposes it would be better if they were visibly empty.

Thanks.

[teylyn]

Hi,

there are several strategies around this:

if the value returned by the formula is a number, you could use the custom format ...

0;;;

... to suppress zero values.

Or, you could use an IF() statement to test what the reference returns, like

=if(or([file.xls]'Sheet1'!A1=0,isblank([file.xls]'Sheet1'!A1)),"",[file.xls]'Sheet1'!A1)

(not tested)

cheers