formulas blanks vs zeros
 

I have to convert Excel worksheets into format readable by Access. My only
problem now is between the two worksheets. When pulling data from one, using
formulas, when there is a blank instead of a number the spreadsheet pulling
the data places a "0" instead of leaving blank. I have tried to write an IF
statement but that then changed not only my blanks but when I had a "0" it
left it blank. Can someone help me?

formulas blanks vs zeros
 

Try

=IF(A2="","",A2)


replace A2 with your data that returns zero for blanks, you probably used 0
instead of ""


--
Regards,

Peo Sjoblom



"Dallasbutterfly" wrote in
message ...
I have to convert Excel worksheets into format readable by Access. My only
problem now is between the two worksheets. When pulling data from one,
using
formulas, when there is a blank instead of a number the spreadsheet
pulling
the data places a "0" instead of leaving blank. I have tried to write an
IF
statement but that then changed not only my blanks but when I had a "0" it
left it blank. Can someone help me?