![add text to numbers custom formatting excel add text to numbers custom formatting excel](https://www.automateexcel.com/excel/wp-content/uploads/2020/07/PIC-01-4.png)
![add text to numbers custom formatting excel add text to numbers custom formatting excel](https://cdn.extendoffice.com/images/stories/doc-excel/add/doc-add-qoutes-around-number-text-4.png)
![add text to numbers custom formatting excel add text to numbers custom formatting excel](https://excelnumber.com/wp-content/uploads/text-with-number.JPG1_-1.jpg)
Within quotation marks, you can add any text. Question marks can also be used for fractions. If you want to align the decimal points, use the question mark. Please note: Conditional formatting rules offer much more color options. You can use this for showing numbers in thousands or millions as well (scroll down for more information). Please note: You need at least one semicolon, otherwise Excel will interpret it as “General” The digit won’t be displayed, if there is a preceding zero.Īdd a 0 (zero) if there should for sure be a digit displayed, even if it’s a zero.Īdd the percentage sign % if you want to display a number as percentage.ĭon’t use any sign if you want to hide number.