Thread: Stop 150.00 in Exel Beta showing as 1.50.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 618
Default Stop 150.00 in Exel Beta showing as 1.50.
"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 QuoteReply With Quote