Re: Formatting cells

2018-12-06 Thread David Robley
On 7/12/18 2:46 pm, Brian Barker wrote: At 03:50 07/12/2018 +, John van Barneveld wrote: I use 4.1.5 on Win10. Is it possible to set numeric formatting so that 4 decimal places are displayed and if the value in a cell is zero then that cell displays as Blank. Yes; enter [=0]"";0. in

Re: Formatting cells

2018-12-06 Thread Brian Barker
At 03:50 07/12/2018 +, John van Barneveld wrote: I use 4.1.5 on Win10. Is it possible to set numeric formatting so that 4 decimal places are displayed and if the value in a cell is zero then that cell displays as Blank. Yes; enter [=0]"";0. into the "Format code" box. I trust this hel

Formatting cells

2018-12-06 Thread John van Barneveld
I use 4.1.5 on Win10. Is it possible to set numeric formatting so that 4 decimal places are displayed and if the value in a cell is zero then that cell displays as Blank. Thanks John van Barneveld --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/an