Removing $ symbol from imorted data

Giganews Newsgroups
Subject: Removing $ symbol from imorted data
Posted by:  Ricardo (richwhiteo…@hotmail.com)
Date: Tue, 14 Oct 2003

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

Replies