Small formatting problem

[Tony Miall]

Morning all

I have some cells with a format of ### which leaves them blank when they equal 0. Problem is when I write a number with a decimal oplace it auyomatically rounds up or down ignoring the decimal.

So when the cell is zero I want it to be blank and when not to show the full value entered.

Any help appreciated

Thanks

 

[VoG]

Try a Custom format 0;0;""

 

[Tony Miall]

This gives the same result. entered 1.5 and it rouded up to 2

 

[VoG]

How many decimal places do you require?

 

[lenze]

Maybe
#.#;-#.#;""

lenze

 

[Tony Miall]

geez you blokes are quick,

I needed 1 decimal place. Lenze format worked. So problem solved.

Thanks very much