+ Reply to Thread
Results 1 to 3 of 3

Can't get the (zero) = 0 in J column. Excel 2003

  1. 02-13-2010, 05:52 AM #1
    kotoma
    kotoma is offline
    Registered User
    Join Date
    02-08-2010
    Location
    gävle
    MS-Off Ver
    Excel 2003
    Posts
    17

    Can't get the (zero) = 0 in J column. Excel 2003

    Hi,

    Don't know how to get it.

    In column J, Cad Hrs.
    How to make to display (0), instead of (-0,02) when I just do other work than Cad Work?

    I need to separate type of work according to price hour, overtime, and so on.

    Anybody with a tip?

    Thanks
    Kotoma
    Attached Files Attached Files
    Last edited by kotoma; 02-13-2010 at 11:52 AM.
    Reply With QuoteRegister To Reply
  2. 02-13-2010, 07:23 AM #2
    ncmay
    ncmay is offline
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: Can't get the (zero) = 0 in J column. Excel 2003

    Try the attached workbook.
    Some formulas have been modified and the display of zero values was turned on.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 02-13-2010, 11:41 AM #3
    kotoma
    kotoma is offline
    Registered User
    Join Date
    02-08-2010
    Location
    gävle
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Can't get the (zero) = 0 in J column. Excel 2003

    Thank you ncmay!!
    You did very good job.

    Have a nice day.

    Kotoma
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1