+ Reply to Thread
Results 1 to 6 of 6

convert to number format in column A

  1. #1
    Registered User
    Join Date
    02-23-2015
    Location
    hk
    MS-Off Ver
    window7
    Posts
    240

    convert to number format in column A

    dear sir

    attached with file which code cannot change the column A into
    number format. after code run, the left GREEN COLOR top corner in cell of column A
    should disappear.

    Thanks
    tom
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,754

    Re: convert to number format in column A

    Selection.NumberFormat = "General"

    works
    Glenn



  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,820

    Re: convert to number format in column A

    Hello
    Select column A >> Data tab >> Click 'Text to Columns' >> Click 'Finish' .. That's all
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  4. #4
    Forum Contributor tax112's Avatar
    Join Date
    02-28-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2003 | 2010
    Posts
    365

    Re: convert to number format in column A

    Quote Originally Posted by hktom View Post
    dear sir

    attached with file which code cannot change the column A into
    number format. after code run, the left GREEN COLOR top corner in cell of column A
    should disappear.

    Thanks
    tom
    Try:
    PHP Code: 
    Sub test()
        [
    a1:A12400] = [a1:A12400*1]
    End Sub 

  5. #5
    Registered User
    Join Date
    02-23-2015
    Location
    hk
    MS-Off Ver
    window7
    Posts
    240

    Re: convert to number format in column A

    Great it solved. Thanks All

  6. #6
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,820

    Re: convert to number format in column A

    You're welcome. Glad we can offer some help for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need formula or code to convert number(s) from custom format to number format
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-12-2015, 07:44 PM
  2. Replies: 1
    Last Post: 12-15-2014, 08:46 PM
  3. Replies: 1
    Last Post: 04-24-2014, 12:25 AM
  4. Convert date and time in serial number format to text format
    By nda13112 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-11-2013, 02:45 PM
  5. Excel: How to convert time format into number format that can be added?
    By Frances Jones in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2012, 04:10 PM
  6. Replies: 1
    Last Post: 07-29-2005, 04:05 PM
  7. [SOLVED] Convert numbers from text format to number format
    By merlin68 in forum Excel General
    Replies: 4
    Last Post: 04-12-2005, 09:06 AM

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