View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Stop 150.00 in Exel Beta showing as 1.50.

Ross,
I haven't got beta myself but your problem appears to be that
fixed decimals is set to 2 places.

In Excel 2003, this is set in Tools==Options==Edit==Fixed dec places so
if you can find the beta equivalent ......

HTH

"Ross Schweitzer" wrote:

With the new Beta version of Exel I cannot prevent [say] 150.00 showing as
1.50.
The previous version, I just enter[say] 150 and the cell displays 150.00. I
do not think I am that stupid, but!
Ross Schweitzer
Melbourne, Australia.