+ Reply to Thread
Results 1 to 5 of 5

Number stored as text

  1. 04-26-2007, 08:43 AM #1
    Sharp
    Sharp is offline
    Forum Contributor
    Join Date
    12-04-2006
    Posts
    201

    Number stored as text

    Hi,

    can anyone help with the following.

    I'm trying to use VBA code to convert certain cells from a number stored as text to a number.

    any ideas

    thanks
    Reply With QuoteRegister To Reply
  2. 04-26-2007, 08:50 AM #2
    jetted
    jetted is offline
    Valued Forum Contributor
    Join Date
    12-16-2004
    Location
    Canada, Quebec
    Posts
    363
    maybe this can help
    Please Login or Register  to view this content.
    Denis

    Please always attach the sample workbook without sensitive information when asking for help

    To add a module
    Press Alt + F11 (this is the Visual Basic Environment)
    Insert Menu, select Module
    Past code there
    Close Visual Basic Environment (X)
    Reply With QuoteRegister To Reply
  3. 04-26-2007, 09:30 AM #3
    Sharp
    Sharp is offline
    Forum Contributor
    Join Date
    12-04-2006
    Posts
    201
    Hi,

    thanks, doesn't seem to have any affect. What does the 'CINT' and 'CLNG' do???

    thanks
    Reply With QuoteRegister To Reply
  4. 04-26-2007, 09:41 AM #4
    antoka05
    antoka05 is offline
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628
    Add this instruction before the 'End Sub' row in the code of Jetted:

    Please Login or Register  to view this content.
    You can also use the code for a range:
    Please Login or Register  to view this content.
    Regards,
    Antonio
    Last edited by antoka05; 04-26-2007 at 09:45 AM.
    Reply With QuoteRegister To Reply
  5. 04-27-2007, 07:52 AM #5
    jetted
    jetted is offline
    Valued Forum Contributor
    Join Date
    12-16-2004
    Location
    Canada, Quebec
    Posts
    363

    Wink

    Quote Originally Posted by antoka05
    Add this instruction before the 'End Sub' row in the code of Jetted:

    Please Login or Register  to view this content.
    You can also use the code for a range:
    Please Login or Register  to view this content.
    Regards,
    Antonio
    Thanks Antonio for correcting my code
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1