Results 1 to 2 of 2

Thread: CR 11 Formatting a Formula Field?

  1. #1

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

    CR 11 Formatting a Formula Field?

    Hey,
    I got a formula field that I am using to display 2 numbers coming from 2 different database fields. The problem is, that CR is adding 2 decimal places and a comma for the thousands seperator. How can I remove this formatting in a formula field?

    Thanks!

  2. #2

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

    Re: CR 11 Formatting a Formula Field?

    I have:
    VB Code:
    1. {Header.Header_Number} & "-" & {Header.Header_Draw_Number}

    but it outputs 45,998.00-0.00

    I need to remove the comma and decimal points fromt the display... anyone have an idea?

Posting Permissions

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



Click Here to Expand Forum to Full Width