Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post

    Post

    I'm trying to alter my quote and invoice forms to show a total of less then $1.00 without a "0" in the dollar column.

    What I am currently getting is "0.50" for displaying 50 cents in the totals column.

    What I would like to have displayed (and printed of course) is " .50" without the first "0".

    This has nothing to do with not showing zeros when there is no number in the cell............I already have that set up. This is only in relation to cash amounts that are less then 1 dollar.


    Sort of a silly little thing but it would be nice if I can manage to make the change.

    Thanks,
    BH

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post
    Format the cells using a Custom Format of #.00
    Jerry

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts
    [quote name='bhdavis' post='781062' date='22-Jun-2009 12:54']What I am currently getting is "0.50" for displaying 50 cents in the totals column. What I would like to have displayed (and printed of course) is " .50" without the first "0".[/quote]
    Create a custom format using "#" as the units digit, such as: #,###.00_);(#,###.00)
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thanks guys. Thought it might be a custom format but I've never done anything with that. Works great !!

    BH

Posting Permissions

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