Results 1 to 9 of 9

How to get rid of $ signs in cells?

Threaded View

Andyc7 How to get rid of $ signs in... 08-30-2007, 05:35 AM
SamuelT Hi, If I understand right... 08-30-2007, 06:54 AM
arthurbr As I couldn't open your file... 08-30-2007, 06:55 AM
Andyc7 Thank you for the advice.... 08-30-2007, 01:26 PM
Andyc7 I don't understand what has... 08-30-2007, 04:02 PM
mpquin Are the cells formatted as... 08-30-2007, 04:17 PM
  1. #1
    Registered User
    Join Date
    08-24-2007
    Posts
    20

    How to get rid of $ signs in cells?

    Can anyone help? I have got a spreadsheet with information I have imported from the web. I want to do a simple sum of =g/e but because the imported information is in dollar form when I put the formula in it will not let me do the sum. If, however, I change every individual cell to numbers manually then I can do the sum. Is there any way i can change the cells to numbers any other way than doing each one individually?
    BTW I have tried selecting the whole column and formatting cells to numbers but to no avail.

    Book1.zip
    Forgot to add this to show you what I mean.
    Last edited by dominicb; 08-30-2007 at 06:30 AM. Reason: Put message and attachment into same thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1