Step 1 of 3
0:00/ par 2:30

Tidy Data · Lesson 16

Number formats

MissionGuided

Rosa is presenting the menu to her business partner tomorrow. Right now prices show as 4.5 and margins as 0.69 — not very professional.

Select the prices B2:B13 and choose Currency ($) from the number format menu in the toolbar (or press Ctrl+Shift+$).

Show · Number formats

Format menu · Ctrl+Shift+$ · Ctrl+Shift+%

A format changes how a number looks, not the number itself. 4.5 can show as $4.50, 0.7 as 70%.

The value stays 4.5 — you'll still see it in the formula bar.

Using a hint costs the “no hints” star.
Use the toolbar above the sheet, then press Check.
B2
fx
ABCD
1
Item
Price
Margin
Cost
2
Espresso
2.8
0.71
0.81
3
Americano
3.6
0.74
0.94
4
Cappuccino
4.5
0.69
1.4
5
Flat white
4.2
0.68
1.34
6
Latte
4.5
0.7
1.35
7
Mocha
4.95
0.64
1.78
8
Chai latte
4.25
0.66
1.45
9
Hot chocolate
3.95
0.62
1.5
10
Croissant
3.25
0.58
1.37
11
Blueberry muffin
3.5
0.6
1.4
12
Banana bread
3.8
0.63
1.41
13
Toastie
6.75
0.55
3.04
14
 
 
 
 
15
 
 
 
 

Type your formula, press Enter to confirm, then Check (or Ctrl+Enter)