Forum Discussion

Copper Contributor

Apr 10, 2019

Formula to add a comma to a number as well as a decimal even when .0

I am pulling information from one tab (Tab name is Stats and the cell is formatted as a number) to another (Tab name is Stat FS). I need the formula to carry over the decimal even if it's a .0, but n...

Formulas and Functions

Twifoo

Silver Contributor

Apr 11, 2019

I haven’t tested, but try this custom format:
#,##0.0#

cpavl1113
Copper Contributor
Apr 11, 2019
Twifoo Unfortunately that added a decimal point to every cell. I just need it in the cells that originally have decimal points. The .1, .2, .3 etc show up, but the .0 do not.

Attached is the document, if you want to see the entire thing.
DRAFT.xls6.7 MB
- Twifoo
  Silver Contributor
  Apr 11, 2019
  Modify the custom format to this:
  #,##0.##
  - cpavl1113
    Copper Contributor
    Apr 11, 2019
    Twifoo That adds a decimal point to everything, but no .0 where I need it and decimal points in cells that I don't need it.