You can use an IF formula similar to the following:

=IF(A1=0,0,A1/1000000)
--
Kevin Backmann


"GKS" wrote:


Can anyone help? I am new to excel but I am trying very hard to learn
ASAP, The problem is that I have a column of numbers that go on for
thousands of rows. This data will change weekly as it is imported in
from another program. using the delimiter function but the column will
stay the same, in this example it is column U. Below is a snapshot of
some of the rows in U. I used the formula U##/1000000 to give the
answers in the V column then I simply hide the U column, but as you can
see when the imported data is all zeros it returns a value message. Is
there any way that in the simple formula I have used I could add
something that basically says divide amount in cell by 1000000 but if
the data in the cell = 0 then return 0

U V
0,000000 #VALUE!
0,000000 #VALUE!
972,000,000 972
342,000,000 342
266,000,000 266
12,570,000,000 12570
1,920,000,000 1920
8,640,000,000 8640
5,400,000,000 5400

Thanks in anticipation of any help


--
GKS
------------------------------------------------------------------------
GKS's Profile: http://www.excelforum.com/member.php...o&userid=32815
View this thread: http://www.excelforum.com/showthread...hreadid=534528