Hot Student Stories

Why do you NOT key in dollar signs even though you want to show on the spreadsheet on Mircrosoft Excel?

Ronald Miller

in Studying

1 answer

1 answer

Roger Moore on April 9, 2019

A dollar is a symbol of text, so if you write something like $4, that is going to be treated like a piece of text and not 4 dollars, which is what you want. That means that you can use in calculations, that is what it is very likely that you also want to do. You will notice that it is left aligned in the cell, the text is always, and not right-aligned as numbers are. So what you have to do is type in the number 4, and then the format of the currency, and then it will display the dollar sign. Will continue to be a number, and you will be able to use in the calculations.

Add you answer