+ Reply to Thread
Results 1 to 4 of 4

Need to Conditional Format Custom Number

  1. #1
    Forum Contributor
    Join Date
    08-08-2006
    Posts
    203

    Need to Conditional Format Custom Number

    I currently have the problem solved in Excel 2007, but my User will be using 2002, and its telling me my solution isnt compatible.

    I have one textbox which needs to be formatted to 10 digits so the precededing zeros will show up.
    How can I do this so when the textbox is output to Sheet1, the cell it ends up in will retain the custom number format

    example:
    0847328397

  2. #2
    Forum Contributor
    Join Date
    01-06-2004
    Location
    Carbondale CO
    Posts
    245
    Format Cell>Number>Custom
    Type in 10 zeros
    A cell formated in this manner will display 000000001 when 1 is entered.

    HTH
    Casey

  3. #3
    Forum Contributor
    Join Date
    08-08-2006
    Posts
    203
    Quote Originally Posted by Casey
    Format Cell>Number>Custom
    Type in 10 zeros
    A cell formated in this manner will display 000000001 when 1 is entered.

    HTH
    Ok, now how to I do that to a textbox in a user form.

    For a long question-

    The user form has 20 textboxes
    only one of them requires the 10 digit custom format
    the number of cells the textboxes post to the sheet varies each time data is inputted and they are offset from the cells above them so formatting all the cells in the column is not an option, and there is no way to know which cell will need the custom format until the data is pasted to the sheet from the Userform.

    So, I have one textbox which needs to be formatted to 10 digits so the precededing zeros will show up.
    How can I do this so when the textbox is output to Sheet1, the cell it ends up in will retain the custom number format

    example:
    0847328397
    Last edited by iturnrocks; 01-19-2007 at 07:02 PM.

  4. #4
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Quote Originally Posted by iturnrocks
    So, I have one textbox which needs to be formatted to 10 digits so the precededing zeros will show up.
    How can I do this so when the textbox is output to Sheet1, the cell it ends up in will retain the custom number format

    example:
    0847328397
    You can use this code for the text box:
    Please Login or Register  to view this content.

+ 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