View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dallasbutterfly Dallasbutterfly is offline
external usenet poster
 
Posts: 1
Default 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?