Results 1 to 3 of 3

Thread: [RESOLVED] Formatting Numbers CR11

  1. Jul 12th, 2006, 02:26 PM #1
    Besoup
    Besoup is offline

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Resolved [RESOLVED] Formatting Numbers CR11

    Hey,
    I got a bunch of number I am showing in the detail. I need them to display as 5 digits no matter what. If they are less than 5 digits I need them to have leading zeros.

    IE.
    999 should be 00999

    anyone know how to do this in crystal?
    Reply With Quote Reply With Quote
  2. Jul 12th, 2006, 03:26 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Formatting Numbers CR11

    Create a formula and use the ToText function

    ToText(123,"00000")
    Reply With Quote Reply With Quote
  3. Jul 13th, 2006, 07:25 AM #3
    Besoup
    Besoup is offline

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2001
    Location
    Mass USA
    Posts
    1,674

    Re: Formatting Numbers CR11

    perfect, thanks!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width