| Topic List | Page List: 1 |
|---|---|
| Topic | Excel Question |
| MartinFF7 07/26/19 10:44:01 AM #6: | Instead if F21 I'd put TEXT(F21,"0.0%") (or more zeroes after decimal if you want more points. It may also be #.#% instead, I forget which to use in which case but there is a subtle difference behind the two. That'll force in the format in a concatenate situation (where you're already put of the number realm and into text anyhow) TEXT function is highly versatile at making numbers appear as you want them to, including specific date formats... ... Copied to Clipboard! |
| Topic List | Page List: 1 |