copy column of data from one sheet to another

when i copy a column of data from sheet1 to sheet2 the cells that contain data come across ok. But those cells that are blank come across as a 0. I need them to be blanks. What is the proper procedure to the transfer

Lo there Genebu,

There are many ways you can do this depending on various factors. For instance, when you copy the data over to the next sheet, are the resulting values needing to be updated depending on what's been entered into the corresponding cells in the reference sheet?

As mentioned, many ways, many explanations. Best to take a look at this very helpful page:

http://office.microsoft.com/en-us/ex...005199879.aspx

All you need to know about hiding 0 values.

Enjoy

Hope this helps.