Number formats (currency, percentage, date) in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

Column A contains raw numbers: 1000 (a number), 0.25 (a decimal), and 44927 (a date serial number). Column B will show these numbers formatted as currency, percentage, and date respectively.

Cell	Value
A1	1000
A2	0.25
A3	44927
B1	1000
B2	0.25
B3	44927

Formula Trace

=TEXT(B1, "$#,##0.00") & ", " & TEXT(B2, "0.00%") & ", " & TEXT(B3, "mm/dd/yyyy")

Step 1: TEXT(B1, "$#,##0.00")

Step 2: TEXT(B2, "0.00%")

Step 3: TEXT(B3, "mm/dd/yyyy")

Step 4: "$1,000.00" & ", " & "25.00%" & ", " & "12/31/2022"

Cell Reference Map

    A       B
1 | 1000  | 1000  
2 | 0.25  | 0.25  
3 | 44927 | 44927 

Arrows: B1 -> TEXT currency, B2 -> TEXT percentage, B3 -> TEXT date

Cells B1, B2, and B3 are referenced for formatting as currency, percentage, and date respectively.

Result

    A       B       C
1 | 1000  | 1000  | $1,000.00, 25.00%, 12/31/2022
2 | 0.25  | 0.25  | 
3 | 44927 | 44927 | 

Cell C1 shows the combined formatted output: currency for B1, percentage for B2, and date for B3.

Sheet Trace Quiz - 3 Questions

What does the formula TEXT(B1, "$#,##0.00") produce when B1 is 1000?

A "1000"

B "$1,000.00"

C "$1000"

D "1,000.00"

Key Result

TEXT(value, format_text) converts numbers to text with specified number formats like currency, percentage, or date.