Easy answer?

aaronst · Apr 26th, 2002, 02:57 AM

I am hoping that you may be able to help.

We have a bizarre problem that we are having trouble finding a solution for with in excel 2000.

We are creating simple, flat statement figures (no calculations) within an excel workbook.

The problem is:-

We enter a figure, e.g £233.06 and save the workbook.

When we next open the file it has changed the figure to e.g £233.08..????

Why is excel adding this extra 2p (GBP) in this cell, as there is no formatting in the cell or anything relating to the cell.

Do you think this is a virus, or am I missing something very simple.

Help needed.....

gareth · Apr 26th, 2002, 05:37 AM

Hello Aaron

It might be that your euro converter is on (add-inns)

Check>>Tools>>addins

Then switch it off

Chris Davison · Apr 26th, 2002, 01:33 PM

Aaron,

that's a weird one...

also try your calculation settings : manual / automatic

together with "iterations"

although with no formulae, this is probably as useful as a bottle of shampoo in Ian Duncan-Smith's bathroom....

Apr 26th, 2002, 05:37 AM	#2
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Hello Aaron It might be that your euro converter is on (add-inns) Check>>Tools>>addins Then switch it off __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 02:57 AM	#1
aaronst New Member Join Date: Apr 2002 Posts: 1	I am hoping that you may be able to help. We have a bizarre problem that we are having trouble finding a solution for with in excel 2000. We are creating simple, flat statement figures (no calculations) within an excel workbook. The problem is:- We enter a figure, e.g £233.06 and save the workbook. When we next open the file it has changed the figure to e.g £233.08..???? Why is excel adding this extra 2p (GBP) in this cell, as there is no formatting in the cell or anything relating to the cell. Do you think this is a virus, or am I missing something very simple. Help needed.....

Apr 26th, 2002, 01:33 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Aaron, that's a weird one... also try your calculation settings : manual / automatic together with "iterations" although with no formulae, this is probably as useful as a bottle of shampoo in Ian Duncan-Smith's bathroom....