Removing $ symbol from imorted data

  • Thread starter Thread starter Ricardo
  • Start date Start date
R

Ricardo

When I import information from the web eg stock prices
etc, some of it comes as $4.25 instead of 4.25. I cannot
manipulate the data in this format and I have tried the
Format - Cells - Number - Currency - None option but it
does not work. Help apppreciated. Thanks
 
Have you tried Search and Replace to remove the dollar sign? Enter $ in the Search For box, and
leave the Replace With box empty.
 
Back
Top