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
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
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