Question #12200278

How to get MS Excel Budge to record ACTUAL dollar and cents?

I'm working on a "Family Budget" sheet in Microsoft Excel. In one of the fields for the bill, it's asking me to enter a "projected" cost and then the next field is the "actual cost". I put the same amount in each field because I know that's the exact amount due...the amount is $530.08 However, when I enter 530.08, and press enter or tab, it changes what I entered to read $530. It will not keep the actual, total amount I enter, it's rounding down to the nearest dollar (removing the "cents" due). How do I change this to where it keeps the EXACT dollar amount that I enter in each field of a bill due? Thanks in Advance for your help.

2013-12-02 02:25:24

TELL US , if you have any answer

There is NEVER a problem, ONLY a challange!

The helpinganswers.com is a free-to-use knowledgebase.
  The helpinganswers.com was started on: 02.07.2010.
  It's free to register. Once you are a registered user, you can ask questions, or answer them.
  (Unless registration you can just answer the questions anonymously)
  Only english!!! Questions and answers in other languages will be deleted!!

Cheers: the PixelFighters

  Contact: support@helpinganswers.com

C'mon... follow us!

Made by, history, ect.