How to put a dollar sign


2 Answer(s)


You can use Accounting formats available under 'Format Cells' -> 'Number' tab or you can directly choose the $ symbol from 'Accounting Number Format' drop-down under 'Number' group in 'Home' tab.

You can speed up entering the dollar signs by using the function key F4 when editing the formula, if the cursor is on a cell reference in the formula, repeatedly hitting the F4 key, toggles between no dollar signs, both dollar signs, just the row and just the column.