I need help from Excel users
April 22, 2007 5:23pm CST
I created an Excel document in order to track my payments from different GPT programs. There is one column where i want to put the amount that I earned. But when I put an amount like for example: $4.83 it changes it automatically to $5. I just want to keep the exact amount and it seems that it can't do it. It's driving me crazy. Do you know how to change that? Thank you for your time.
2 people like this
• United States
23 Apr 07
It defaults to round it off to the nearest number, this being the 5, you need to format your cells to currency with 2 numbers past the point sign and if you want to add a dollar sign you need to tell it at this point.
24 Apr 07
You just need to change the decimals setting to allow the field to accept two decimals. Just go to Format Cells and look for the Number tab. Highlight number and set the decimal to two. You can also use the Currency options and it would work the same and it would put the $ sign there for you.
23 Apr 07
Yes, all my friends guided you properly to solve the problem and I don't want to repeat the same. Only I can add, please go through as asylum suggested and format for auto sum for a specific period as you need, so that while you enter the numerical data, you will get final results with less work.