View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ross Schweitzer Ross Schweitzer is offline
external usenet poster
 
Posts: 2
Default Stop 150.00 in Exel Beta showing as 1.50.

Thank you. I re-examined the protocols and found I needed to apply: MICROSOFT
OFFICE BUTTON, thence ADVANCED, thence EDITING OPTIONS thence AUTOMATICALLY
INSERT a decimal point. In PLACES, I set ZERO. Viola! Note that there is NO
pointer in the Cell Format area of Excel. This is vexing.

Ross

"Toppers" wrote:

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.