TEXT function for formatting in Excel - Cell-by-Cell Formula Trace

Sample Data

Sample numbers representing a price, a fraction, a date serial number, and a fraction for formatting.

Cell	Value
A1	1234.567
A2	0.75
A3	43500
A4	0.5

Formula Trace

=TEXT(A1, "$#,##0.00")

Step 1: A1

Step 2: TEXT(1234.567, "$#,##0.00")

Cell Reference Map

1234.567

↓

0.75

↓

43500

↓

0.5

The formula references cell A1 which contains the number 1234.567 to format.

Result

    A           B
1  1234.567   $1,234.57
2  0.75          
3  43500         
4  0.5           

The formula in B1 shows the formatted text "$1,234.57" based on the number in A1.

Sheet Trace Quiz - 3 Questions

What does the format code "$#,##0.00" do in the TEXT function?

A Adds a dollar sign, comma for thousands, and shows two decimals

B Removes decimals and adds a percent sign

C Shows the number as a date

D Rounds the number to the nearest whole number without symbols

Key Result

TEXT(value, format_text) converts a number to text with the given number format pattern.