Results 1 to 3 of 3

Thread: formatnumber as "0000"

  1. Sep 30th, 2007, 11:34 PM #1
    shukla
    shukla is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    nasik,india
    Posts
    909

    formatnumber as "0000"

    how to format any number type field in crystal report as "0000" i.e. no.12 will appear as 0012 in my report?
    i m using cr. 9.0
    thanks.
    WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST
    Reply With Quote Reply With Quote
  2. Oct 1st, 2007, 01:10 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: formatnumber as "0000"

    Create a formula and use the ToText function

    ToText({Number Field},"0000")
    Reply With Quote Reply With Quote
  3. Oct 1st, 2007, 11:37 PM #3
    shukla
    shukla is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    nasik,india
    Posts
    909

    Re: formatnumber as "0000"

    thanks.i will try this.
    WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST
    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