Referencing another worksheet

[Access::Student]

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?

 

[Gord Dibben]

=IF(='Master-H'!AW105="","",='Master-H'!AW105) to not display zeros.

What do you mean by "rounding decimals"?


Gord Dibben MS Excel MVP

 

[Access::Student]

Sorry I'll try and explain myself better, I'm using 2007. And the part about
the decimals I figured out, I actually had my data type in access set to int
so it wasn't importing them correctly.

So the problem I'm having is that the other cells that should be blank(NULL)
have 0 in them. I'd already figured out how to remove them by formating (
0;-0;;@ ) so that they don't display in excel, but when I import the data
into access it imports the 0's instead of NULL, which is a problem for me. So
I need to do something outside of formatting and actually have NULL values in
those cells

 

[Access::Student]

Sorry I read too quickly. I thought you mean to add the second formula to
formatting. It does work if it's put into the actual cell. thanks