View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sue Sue is offline
external usenet poster
 
Posts: 285
Default Create a document from a spread sheet using data from another spre

Hey!

I need a little help here. I'm trying to create a "contract" in a sread
sheet using data collected in a diferrent spread sheet. I have a few rows
filled with dates and others in blank in case I might write a new date if I
need to. I need to copy these rows to a diferrent spread sheet and when there
are dates in them the data is trasnfered well but when the rows are blank I
get a nasty 0 on the new sheet and I just want the space to come out blank.
Is there a formula to make this happen?

ex sheet 1 trasnfer to sheet 2
A B A B
1 1/1/09 1 1/1/09
2 2 0
3 2/3/09 3 2/3/09
--
Sue :o)