Results 1 to 2 of 2
  1. #1
    yamalady is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2013
    Location
    Ohio
    Posts
    17

    Format Function...need to convert numbers to a 0000-0000 format

    Hi...I have data similar to this:

    8000
    8001-1952
    8520-1234
    8010

    I need a formula to make all my numbers into the same format. Any number without the ending (-####), I need to convert to -0000 as shown below. What would be the correct formula? I tried using the Format Function, but it keeps adding the Zero's in front of the number instead of behind the number.

    8000-0000
    8001-1952
    8520-1234
    8010-0000

    Thank you in advance!!

  2. #2
    yamalady is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2013
    Location
    Ohio
    Posts
    17
    I figured it out!.....Format(Myvalue,,"#""-0000""")

Please reply to this thread with any new information or opinions.

Similar Threads

  1. CDate function to convert from dd.mm.yyyy format
    By GregTheSquarePeg in forum Queries
    Replies: 7
    Last Post: 10-11-2013, 07:11 AM
  2. Format Does Not Convert Check Box value
    By CementCarver in forum Reports
    Replies: 2
    Last Post: 04-23-2013, 02:19 PM
  3. Replies: 4
    Last Post: 03-12-2013, 06:49 PM
  4. Convert seconds to HH:MM:SS format
    By sai_rlaf in forum Access
    Replies: 2
    Last Post: 01-19-2012, 12:57 AM
  5. Phone number in (000) 000-0000
    By Ajay in forum Queries
    Replies: 9
    Last Post: 03-12-2010, 11:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums