Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

skinnylegs

macrumors 65816
Original poster
May 8, 2006
1,427
55
San Diego
I am using numbers for my accounts receivable. I have a formula which some dude created for me *years* ago that I used in Claris Works and it *seems* to work most of the time in Numbers. Anyway, the formula provides for either a debit or a credit and a balance.

This is how it normally looks.....

However, for some weird reason the balance gets all screwed up whenever I enter cents into the equation.

Check this out. I entered 5192 in the credit section and it changed the balance accordingly.....

However, when I add the 70 cents (.70) to the credit, the balance looks all messed up.....

It must be something I'm doing or not doing. It always is. LOL Any help would be greatly appreciated.
 

Attachments

  • Picture 5.png
    Picture 5.png
    123.7 KB · Views: 59
  • Picture 6.png
    Picture 6.png
    10.2 KB · Views: 49
  • Picture 7.png
    Picture 7.png
    12.1 KB · Views: 62
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.