Posted 8 September 2017, 2:47 pm EST
I need to have a spreadsheet display numbers with 2 decimals places, but if the cell is click, the number/value is shown in the top formula/input bar with all the decimal places that it has. For example, in Excel, the cell has "11.2345" in its, but since the celltype is set to Number with 2 decimals, it displayed as 11.23. However, if you click on the cell, the top "formulat/input" bar showed 11.2345.
If there a way to do that in Farpoint, and to get and keep the actual number with all the precision even though the "visual" displayed number is only 11.23?
I try to do:
Thanks in advance for your help!