Tony Miall
Active Member
- Joined
- Oct 16, 2007
- Messages
- 304
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
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