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
Bookmarks