View Single Post
  #3   Report Post  
Old January 19th 18, 04:01 AM
killme2008 killme2008 is offline
Junior Member
 
First recorded activity by ExcelBanter: Jan 2018
Posts: 16
Default

Quote:
Originally Posted by mytyab View Post
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