ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   In Excell how do I just type in an amount w/o it inserting a $ (https://www.excelbanter.com/excel-worksheet-functions/35612-excell-how-do-i-just-type-amount-w-o-inserting-%24.html)

N. Parrish

In Excell how do I just type in an amount w/o it inserting a $
 
I am putting in Hours for Students. I have like 152.5 hours and when I put in
into a row or column it automatically enters a $ symbol. What can I disable
(if anything) to make it not do that?

Anne Troy

Format--Cells, and choose Number tab. Then choose Number, 2 decimals (or
however many you want), instead of currency.
*******************
~Anne Troy

www.OfficeArticles.com


"N. Parrish" <N. wrote in message
...
I am putting in Hours for Students. I have like 152.5 hours and when I put

in
into a row or column it automatically enters a $ symbol. What can I

disable
(if anything) to make it not do that?





All times are GMT +1. The time now is 06:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com