Forum Discussion

cpavl1113's avatar
cpavl1113
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's avatar
cpavl1113
Copper Contributor
Apr 10, 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's avatar
Twifoo
Silver Contributor
Apr 10, 2019
Try the General format.
  • cpavl1113's avatar
    cpavl1113
    Copper Contributor
    Apr 10, 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.