How to put a dollar sign

please explain

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.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)