+ Reply to Thread
Results 1 to 2 of 2

Number Store As Text ????

  1. #1
    Registered User
    Join Date
    06-07-2006
    Posts
    58

    Number Store As Text ????

    I have few textbox in a userform in which I want to put Number (with coma).
    My problem is these values in the texbox are stored in my my Excel Worksheet as text and therefore, create some problems to generate a graph later on.

    Anyone knows a macro that Convert Text as Number ?
    I know if I go on each cells and press F2, it does automatically the convertion but writing a macro...???

    Thanks

    Herve

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Either one of the two below lines will convert cell A1 to a value from text:
    Please Login or Register  to view this content.
    HTH

    Jason

+ Reply to 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