R
RichB
I have a spreadsheet that is linked to another. Within the spreadshee
I have two cells in sheet1 linked to sheet2.
Sheet2!B2 = Sheet1!B3&""&Sheet1!B4
My problem is that if Sheet1!B3 is blank it returns a zero on the lin
on Sheet2!B2
0F
It should just be F
If both B3 and B4 are blank it gives me
00
I turned off zero values in all spreadsheets affected and it still doe
not work. Am I stuck with coding this out or is there something I ma
be missing.
Thanks
Rich
I have two cells in sheet1 linked to sheet2.
Sheet2!B2 = Sheet1!B3&""&Sheet1!B4
My problem is that if Sheet1!B3 is blank it returns a zero on the lin
on Sheet2!B2
0F
It should just be F
If both B3 and B4 are blank it gives me
00
I turned off zero values in all spreadsheets affected and it still doe
not work. Am I stuck with coding this out or is there something I ma
be missing.
Thanks
Rich