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

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.
- Twifoo
  Silver Contributor
  Apr 11, 2019
  Try the General format.
  - cpavl1113
    Copper Contributor
    Apr 11, 2019
    Twifoo It's already at the general format. For some reason, the general format doesn't pull exact data the way it was entered from another cell. Not sure why. I would think that if I have a formula that pulls data from another cell, it would copy that data exactly, but it does not.