Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop 150.00 in Exel Beta showing as 1.50.
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop 150.00 in Exel Beta showing as 1.50.
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop 150.00 in Exel Beta showing as 1.50.
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stop exel from rounding | New Users to Excel | |||
Setting to stop error messages from showing? | Excel Discussion (Misc queries) | |||
Stop excel icon showing at the bottom when opening spreadsheets | Excel Discussion (Misc queries) | |||
Stop excel icon showing at the bottom when opening spreadsheets | Excel Discussion (Misc queries) | |||
How do I stop the Reviewing toolbar from showing up in Excel? | Excel Discussion (Misc queries) |