Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what do i change in options to correct
i am working on a spreadsheet with $ figures example (1301.15 ) but after i
enter this figure in it rounds up to 1301.2, is there a option to turn this off and leave my figures as i have entered them, thx in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what do i change in options to correct
Check your formatting or your column length.
If it is formatted to General and the column isn't long enough it will round. You can make sure by setting your number to a Numbers format with 2 decimal places. Hope this helps. Roy wrote: i am working on a spreadsheet with $ figures example (1301.15 ) but after i enter this figure in it rounds up to 1301.2, is there a option to turn this off and leave my figures as i have entered them, thx in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
World Cup tipping | Excel Worksheet Functions | |||
World Cup tipping | New Users to Excel | |||
Change value in cell | Excel Discussion (Misc queries) | |||
Can I change the default paste options? | Excel Discussion (Misc queries) | |||
How do I set Save Options? | Excel Discussion (Misc queries) |