auto insert $

O

ogawak

Ugh! My mind is blank! I don't remember how to do this, I want the $ to
appear automatically whenever enter numbers in my sheet.

Thanks!
 
F

firefytr

Format the cell as Currency.

Either:

1
Right click cell, select Format Cells, choose Number (tab), selec
Currency.

2
Hit the Currency format toolbar shortcut button (found on th
Formatting toolbar).

3
Select desired cells, hit Ctrl + Shift + 4 (keyboard shortcut)
 
Top