Format Cells

[uberathlete]

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!

 

[Beate Schmitz]

Hello,

use userdefined cellformat: 0.000000,0.000000,0

 

[lenze]

Format>Cells>Number Tab
For category, choose "Custom"
For Type, enter
#.######;(#.######);0

Click OK

lenze

 

[uberathlete]

Wicked. Thanks a lot guys, appreciate it.

 

[uberathlete]

Format>Cells>Number Tab
For category, choose "Custom"
For Type, enter
#.######;(#.######);0

Click OK

lenze

Hi Lenze. When I use that custom format, it returns negative values with a parenthesis. Is there any way to modify it so that negative numbers appear with a minus sign instead? Sorry for the followup question ^_^;

 

[Beate Schmitz]

Hello,

try:

#.######;-#.######;0

(I'm not sure, because I have German Excel)

 

[Peter_SSs]

uberathlete

From my reading of your question, I think that you need this:
0.000000;-0.000000;0