Results 1 to 3 of 3

Custom Format Numbers for account codes

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-21-2004
    Location
    MN
    MS-Off Ver
    Microsoft 365
    Posts
    213

    Custom Format Numbers for account codes

    I need to format a cell so that it will always display the account code directly when managers are entering information into their requisition form. Our account format needs to be:

    4444.4444.22.22

    I guess dots or dashes wouldn't necessarily matter. I have tried some formats, but I don't get the results I am hoping for.

    It just needs to be 4 digits, dot, 4 digits, dot, 2 digits, 2 digits.

    Any suggestions? Thank you!
    Last edited by karstens; 01-14-2011 at 04:16 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