ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   converting number to dollar (https://www.excelbanter.com/setting-up-configuration-excel/449258-converting-number-dollar.html)

mytyab September 16th 13 04:42 AM

converting number to dollar
 
I know this should be easy but it isn't.

I copy html spreadsheets off an web link in an email that has columns of data. One of the fields has dollar amounts like 1,565.00 that are formatted as general. I need to convert this to a dollar amount like $1,565. When I try to format the field to currency, nothing happens. I tried copying and pasting values in all the different formats. I made sure the column isn't locked. I have 3,500 rows of different amounts that I don't want to manually change.


Please tell me what I'm missing.

Alexander Frolov October 1st 13 04:59 PM

Quote:

Originally Posted by mytyab (Post 1613875)
When I try to format the field to currency, nothing happens.

Most likely, there are excess spaces in your column, that prevent the conversion of the column's data to the currency format. If it is the case, then you can use the Trim spaces add-in to get rid of them.

killme2008 January 19th 18 04:01 AM

Quote:

Originally Posted by mytyab (Post 1613875)
I know this should be easy but it isn't.

I copy html spreadsheets off an web link in an email that has columns of data. One of the fields has dollar amounts like 1,565.00 that are formatted as general. I need to convert this to a dollar amount like $1,565. When I try to format the field to currency, nothing happens. I tried copying and pasting values in all the different formats. I made sure the column isn't locked. I have 3,500 rows of different amounts that I don't want to manually change.


Please tell me what I'm missing.

Try
Text to column-general
Then set the format of the cell

Tim Paine December 31st 20 02:16 PM

how to convert numbers to dollars in excel
 
To show numbers as currency, you can apply either the Currency format or the Accounting format.
Select the cells that you want to format and then, in the Number group on the Home tab, click the down arrow in the Number Format box.

Choose either Currency or Accounting.
Currency

With this format:

The decimal points appear aligned in the column.

The currency symbol appears next to the first digit in the cell. (That is, it is not aligned with the other currency symbols in the column.

I hope this helps!
Tim Paine


All times are GMT +1. The time now is 11:21 AM.

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