ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   what do i change in options to correct (https://www.excelbanter.com/excel-discussion-misc-queries/113245-what-do-i-change-options-correct.html)

Roy

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

willwonka

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




All times are GMT +1. The time now is 11:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com