View Single Post
  #4   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.

Dear David, Thanks, it caused me to re-examine the new procedure. I went to
"Microsoft Office" Button thence "Advanced" thence "Places". The default
setting is TWO. I have reset it to zero. There is also a negative option!

Regards,

Ross S

"David Biddulph" wrote:

"Ross Schweitzer" <Ross wrote in
message ...
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!


With earlier versions of Excel it would be:
Tools/ Options/ Edit:
Fixed decimal places.

If that menu path doesn't exist in the 2007 beta I suggest you look up
"fixed decimal places" in the help.
--
David Biddulph