ericsemail
New Member
- Joined
- Sep 23, 2006
- Messages
- 3
Hi, I have two lists set up, and I wrote a loop to loop through both list subtracting the numbers that have corresponding types that appear in both lists. Everything is working great... problem is, on the last number... i have 112 minus 112.04... i store this in a variable and msgbox the variable, i get the right answer in scientific notation, when i output this to the cell, it's in scientific notation.... i'm trying to get this to be.. -.04 and not in scientific notation... not having any luck... i know i can format the cell individually, but the cell will change, so doing it manually won't work.. any help will be great. thanks