Results 1 to 16 of 16

Custom number format with text

Threaded View

karstens Custom number format with text 01-14-2011, 06:34 PM
noexcel=badwork Re: Custom number format with... 01-14-2011, 06:47 PM
TechRetard Re: Custom number format with... 01-14-2011, 08:12 PM
mahju Re: Custom number format with... 01-18-2011, 06:26 AM
karstens Re: Custom number format with... 01-18-2011, 10:40 AM
arthurbr Re: Custom number format with... 01-18-2011, 10:44 AM
karstens Re: Custom number format with... 01-18-2011, 10:56 AM
Marcol Re: Custom number format with... 01-18-2011, 11:36 AM
karstens Re: Custom number format with... 01-18-2011, 11:45 AM
Marcol Re: Custom number format with... 01-18-2011, 11:47 AM
Marcol Re: Custom number format with... 01-18-2011, 11:57 AM
karstens Re: Custom number format with... 01-18-2011, 12:06 PM
Marcol Re: Custom number format with... 01-18-2011, 12:15 PM
karstens Re: Custom number format with... 01-18-2011, 12:24 PM
Marcol Re: Custom number format with... 01-18-2011, 12:28 PM
karstens Re: Custom number format with... 01-18-2011, 12:29 PM
  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