Neat, always looking for options like that - must have mssed it.

Steve

On Wed, 26 Jul 2006 16:51:53 +0100, Gord Dibben <gorddibbATshawDOTca
wrote:

David

Set to 2 decimal places display as you have done.

Then go to ToolsOptionsCalculation and Checkmark "Precision as
displayed"

This is a Workbook setting so will be applied to all sheets in the book.

Note: this will permanently change the value to 21.59

Might be best to do this on a copy of the workbook just for exporting
purposes.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 10:58:30 +0100, "David" wrote:


I have a cell that reads 21.59 [for example] but when I click on it, the
data entry field on the tool bar extends that number to 6 decimal
places.
How do I get Excel to read the number only as 21.59? Assuming that the
two
decimal place version is display only.

I ask this because this data is going to populate a SQL database over
which
I have no control and I don't want my price data displaying on my
website to
6 decimal places!

Thanks
David