Function Text and Combine Cell

Function Text and Combine Cell

The TEXT function returns a number that has been formatted as text using the number format specified. To embed formatted numbers within text, use the TEXT function.

The value and format text arguments are passed to the TEXT function. The value is the number that will be formatted as text and must be a numeric value. If the value already contains text, no formatting is applied. Format text is a text string containing the number formatting codes that should be applied to value. Provide format text as a text string surrounded by double quotes (""). Excel Custom Number Formats contains examples of various number format codes.

Note: The output from TEXT is always a text string. To format a number and maintain the numeric value, apply regular number formatting.

When concatenating a formatted number to a text string, the TEXT function comes in handy. "Sales last year increased by more than $5,300.00," for example, where the number 5300 has been formatted with a currency symbol and a thousands separator. The number formatting will be removed if the TEXT function is not used. This is especially true for dates, which appear as large serial numbers. You can embed a number in text using the TEXT function and the exact number format required.

Example

With the Number in cell A1, the TEXT function can be used like this:
=TEXT(A1,"#,###.00") // returns"5,300.00"

Please Watching My Video

Design by Vannak Vannaro