Results 1 to 6 of 6

change whole column from text to number

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2011
    Location
    France
    MS-Off Ver
    Excel 2007
    Posts
    3

    change whole column from text to number

    I know this will be simple but I am very new to Excel. I have a column which has text stored as numbers. I want to remove the comma in the number, such as this 345,500 to 345500. I can do each on individually but I have around 3000 to change.
    Can some kind soul help a newbie, please?
    Last edited by wotnots; 01-23-2011 at 10:12 AM. Reason: Solved

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