I am new top excel and I have 2 worksheets open. I am importing dat
from worksheet 2 to worksheet 1. If the value is 0 I need it not t
show up. (You dont want 100 0's on an invoice!) Please assist!

Brand

--
Message posted from http://www.ExcelForum.com

Brandi,

You can use Tools - Options - View, and turn off "zero values. This is on a
sheet by sheet basis -- select the desired sheet first. You can also format
specific cells to not show zeroes with Format - Cells - Number Custom, and
a code like:
0.00;-0.00;
The sections are separated by semicolons. the first is for positive
numbers, the second for negative, and the third (where there is nothing) is
for zero values. You can change the first two.


--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"brandim7 " wrote in message
...
I am new top excel and I have 2 worksheets open. I am importing data
from worksheet 2 to worksheet 1. If the value is 0 I need it not to
show up. (You dont want 100 0's on an invoice!) Please assist!

Brandi


---
Message posted from http://www.ExcelForum.com/