View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
willwonka willwonka is offline
external usenet poster
 
Posts: 40
Default 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