View Single Post
  #2   Report Post  
Old October 1st 13, 04:59 PM
Alexander Frolov Alexander Frolov is offline
Junior Member
 
First recorded activity by ExcelBanter: Sep 2012
Posts: 3
Default

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