Hi,
I haven't used excel in a while and have run into a problem which seems
pretty simple.

I've got a simple formula on a certain sheet of the form "='Master-H'!AW105"
, to replicate data on another form.

It work but does two things I don't like. When there are blank values in the
original sheet, it return a '0'; and decimals get rounded. I am pretty sure
it has nothing to do with formatting because exporting the data to access
those two problems still exist.

What am I doing wrong?