Thread
:
Stop 150.00 in Exel Beta showing as 1.50.
View Single Post
#
4
Posted to microsoft.public.excel.misc
Ross Schweitzer
external usenet poster
Posts: 2
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
Reply With Quote
Ross Schweitzer
View Public Profile
Find all posts by Ross Schweitzer