Import Currency Problem

[brandim7]

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

 

[Earl Kiosterud]

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.