how are trailing decimal zeroes within a cell deleted
Hello @kengra,
- Select the entire number that you want to format;
- Right-click inside the selection, and choose the item
Number Format...; - In the dialog that pops up, in the textfield called “Format Code:”, type
0.#
( or if your locale uses the Comma as decimal separator, then type0,#); - Click OK.
HTH, lib
i inadvertently “answered” rather than “commenting”. sorry
I must be doing something wrong. i have a table column consisting of numbers with 0 to 4 decimal digits. the data was entered without trailing zeroes ( i.e. 1.2 not 1.2000). adding the zeroes gives me a different but wrong result. i’ve tried 0.#, #.# through 0.#### & #.#### i suspect i have to 1st clear the control l or R (left or right) formatting but can’t figure out how using your 4.2 book. short of using a non proportional font to align numbers on the decimal point, please help. BTW i am using 6.0. thank you for trying to help.
Hello again @kengra,
To align the numbers at the decimal point, you could use the “?” symbol in your Format Code string as follows:
0.000?
or:
0.0???
For the correct alignment, the used font should indeed be a Monospace font, and the contents should be Right-aligned within the cell.
HTH, lib