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 not to add a .0 if none exists.
I've been told I need another if and a MOD, but for the life of me, I'm not sure exactly where or how to use that. I need everything from the Stat FS tab to read exactly how it does in the Stats tab, so a .0 when there is a .0 and have a comma in numbers that are in the thousands. Can anyone point me in the right direction on this? Thanks!
@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.