Convert or die!

Intermediate Google Sheets

Richie Cotton

Data Evangelist at DataCamp

Formatting numbers

	A	B	C
1	Value	Command	Result
2	1.234	=TO_DOLLARS(A2)	$1.23
3		=TO_PERCENT(A2)	123%

Converting text to numbers

	A	B	C
1	Value	Command	Result
2	'1.23	=ISTEXT(A2)	TRUE
3		=N(A2)	1.23
4		=ISNUMBER(C3)	TRUE

Converting logicals to numbers

	A	B	C
1	Value	Command	Result
2	TRUE	=N(A2)	1
3	FALSE	=N(A3)	0

Converting units of numbers

	A	B	C
1	Value	Command	Result
2	1000	=CONVERT(A2, "ft^2", "m^2")	92.90304

Summary

• TO*() functions format numbers.
• N() changes text to numbers.
• IF(logical, 1, 0) changes logicals to numbers.
• CONVERT() changes the units of a number.

Let's fix some data!

Intermediate Google Sheets