Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from rounding my numbers up?
I am calculating expenses and each time I enter an amount e.g 12.43 excel
rounds it up to 13. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from rounding my numbers up?
Are you sure your example is right?
If the column width is too narrow, excel will only display the rounded number--but in this case, it would be 12. (If you typed 12.73, then excel may display 13.) Try widening the column a bit (or changing to a smaller font) If that's not it, what do you see in the formula bar? If you really see 13, then I would suspect that you have an event macro that's running and rounding (up) that entry. You can find out by opening up your workbook and not allowing macros to run--then see what happens when you test it by typing in a new value. lyndylou wrote: I am calculating expenses and each time I enter an amount e.g 12.43 excel rounds it up to 13. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from rounding my numbers up?
I actually had this exact same problem! It's as simple as adding a space bar to the end of your number!
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from rounding my numbers up?
I actually had this exact same problem! It's as simple as adding a
space bar to the end of your number! Do that makes the cell contents 'text'; -undesirable results will occur in formulas referencing those cells! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel is rounding numbers in ALL formats - how do I stop this? | Excel Discussion (Misc queries) | |||
How do I get excel to stop rounding numbers | Excel Discussion (Misc queries) | |||
Excel won't stop rounding numbers. Please help | Excel Discussion (Misc queries) | |||
How do I stop excel from rounding numbers? | Excel Discussion (Misc queries) | |||
How do I stop numbers from rounding in Excel? | Excel Discussion (Misc queries) |