decimals

[Chris Deach]

I was sent an excel worksheet from another user. I am
formatting and editing the spreadsheet for import into
another program. The spreadsheet contains a column with
numbers that displays 15 decimal places. When I change
the cell or column format to 2 decimals, visually the
number changes to 2 decimals. However, when I place my
cursor in that cell, the formula bar still displays the 15
decimals. I need to ONLY store 2 decimals - how can I
change the format so that the formula bar will display the
2 decimal places that I see visually?

Thanks!!

Chris Deach
404-785-7031
(e-mail address removed)

 

[Frank Kabel]

Hi Chris
goto 'Tools - Options - Edit' and choose 'fixed decimals'.
Note: This will change this data permanently!

 

[Andy B]

Chris

Try:
=ROUND(A1,2)
which will round your figures to 2 decimal places, and forget the rest.

Andy.