Adding text to number is quiet easy with a simple function called CONCATENATE or using the ampersand “&” symbol. I am not going to tell you the same thing here. We are adding custom text to number in a cell with the custom number format feature of Google Sheets. It’s similar to the one available in Excel >Format Cells> Custom Number formats. With this feature we can add custom text to number that can be considered in calculation.
How Adding Custom Text to Number With our Below Tips Different From Concatenate Function?
If you add any text with number using the below method, that number can still be used in functions. It will retain its number format.
Why this Useful or Where Can I Use Such Numbers Added With Custom Text?
In Google Sheets or Excel, instead of formatting the number with currency, I simply use this custom number format to get my desired currency.
Interesting to Read : Convert Any Numbers to Currency or Words Online
Steps to Add Custom Text to Number that Can be Considered in Calculation
- Select the cell where your number resides.
- Go to Format>Numbers>More Formats>Custom Number Format
- Type this ##,#.00 “USD” in the field and click apply.
- The text USD will be added to your number. Similarly you can add any text to the number. Just replace “USD” with any other text.
See the below screenshot for the explanation of the characters used in the Syntax.
As already mentioned above this give you the flexibility in using Currency format in Google Sheets. Use it dynamically to become a smarter spreadsheet user. For more tips visit our page frequently.