Support Board

Date/Time: Sun, 19 May 2024 21:02:21 +0000

Post From: Float values instead

[2020-06-11 15:12:11] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4001
The Number Format doesn't remove float values; it only removes them from displaying. You can use a formula in column H to remove the float values. Start by removing them in the Tick Size, e.g. H21: =1/ROUND(1/J21,0) Spreadsheet Example Formulas and Usage: Removing Floating Point Imprecision