Saved Bookmarks
| 1. |
Solve : Dollar sign in excel 10? |
|
Answer» Hi everybody Is there a way to remove the $ dollar sign I the columns in Excel 10If you mean you have columns showing money amounts (and your local currency setting is the dollar) then select the column(s) and format them as number not currency. Quote from: Geek-9pm on January 28, 2017, 07:43:00 PM Why would you want to change either?If the columns or cells were accidentally formatted as currency but they contain numbers which are not money amounts you would want to change that. Quote from: Geek-9pm on January 28, 2017, 07:43:00 PM Why would you want to change either?In financial applications of spreadsheet software, the 1st amount a the top of a column is typically formatted to show a $ sign but amounts in rows between that top number and the sum at the bottom are usually not preceded with the $ sign. Quote from: soybean on January 29, 2017, 01:30:06 PM In financial applications of spreadsheet software, the 1st amount a the top of a column is typically formatted to show a $ sign but amounts in rows between that top number and the sum at the bottom are usually not preceded with the $ sign.I work in a public finance office (in Britain) and our spreadsheets show £ signs in all of the cells in a column formatted as accounting or currency. This is our CONVENTION when producing reports, statements, etc. Is this a US thing? Quote from: Salmon Trout on January 29, 2017, 01:36:30 PM Is this a US thing?Yes. See the attached image as an example. Alternatively, the currency may be stated just once at the top of a column; for example, the Balance Sheet shown at http://accounting-simplified.com/financial/statements/statement-of-financial-position.html simply notes "USD" at the top of column. [attachment deleted by admin to conserve space] |
|