Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert excel spread sheet into txt.cvs document | Excel Discussion (Misc queries) | |||
How to create a spread sheet for time | Excel Worksheet Functions | |||
how do you to create a spread sheet from scratch | New Users to Excel | |||
how do you to create a spread sheet from scratch | New Users to Excel | |||
Is there an easy way to take data from a spread sheet and have it entered into a Word document? | New Users to Excel |