- Jul 11, 2007
Hi everyone. I have a data array of numbers generated by a Vlookup formula. I would like the formatting of all numbers except those with a value of 0 to be of 6 decimals. For 0 values, I would like the format to have no decimals. I tried doing this with conditional formatting but there's no option to do this. Is there some other way to get this done? Any suggestions would be much appreciated. Thanks!