Thread: Decimal point
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
David David is offline
external usenet poster
 
Posts: 17
Default Decimal point


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