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.
|