Results 1 to 16 of 16

Custom number format with text

Threaded View

  1. #3
    Forum Contributor TechRetard's Avatar
    Join Date
    06-14-2009
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    202

    Re: Custom number format with text

    newb formula of the day

    say you are inputing into cell b1...use data validation, custom formula

    =AND(LEN(B1)=10,CODE(LEFT(B1))>=65,CODE(LEFT(B1,1))>=65,CODE(LEFT(B1,2))>=65,CODE(MID(B1,4,1))=45,CODE(LEFT(B1,4))<=90,CODE(LEFT(B1,5))<=90,CODE(LEFT(B1,6))<=90,CODE(LEFT(B1,7))<=90,CODE(LEFT(B1,8))<=90,CODE(LEFT(B1,9))<=90,CODE(LEFT(B1,10))<=90)
    drag down
    Last edited by TechRetard; 01-14-2011 at 08:50 PM.

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