Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format decimal controls do not work
e are using new computers with a newer version of excel---our existing
programs work fine, except we cannot control number formatting from either the format cell box or the taskbar decimal control. We simply want to kill the decimal places, but it will not allow this. Also when you click on the format cell option you have to do so 3-6 times as it keeps going to the font subscreen rather than the main screen. Otherwise the program works fine and displays everything designed in an earlier version of Excell without problems |
#2
|
|||
|
|||
Jim -
Try Tools, Options, Edit and see if Fixed Decimal and Places is the default. HTH, Carole O "jimcrowl" wrote: e are using new computers with a newer version of excel---our existing programs work fine, except we cannot control number formatting from either the format cell box or the taskbar decimal control. We simply want to kill the decimal places, but it will not allow this. Also when you click on the format cell option you have to do so 3-6 times as it keeps going to the font subscreen rather than the main screen. Otherwise the program works fine and displays everything designed in an earlier version of Excell without problems |
#3
|
|||
|
|||
jim
Not sure what you have going on here. If you type 123 in a cell does it always display as 123.00 and you want it to display 123? FormatStyleNormal. What is Number set to? I leave mine at General so it will not display decimals unless there are decimals. You can hit the "modify" button to change this. Also, if you are entering 123 and it shows as 1.23 then go to ToolsOptionsEdit and uncheck "fixed decimal places". The FormatCells select will usually show the last Tab used. If it is the Font Tab then that will show. Do you have all the appropriate Tabs........Number, Alignment, Font, Border, Patterns, Protection? What is the "taskbar decimal control" or do you mean the "toolbar decimals increase/decrease buttons"? Gord Dibben Excel MVP On Fri, 7 Jan 2005 10:29:04 -0800, "jimcrowl" wrote: e are using new computers with a newer version of excel---our existing programs work fine, except we cannot control number formatting from either the format cell box or the taskbar decimal control. We simply want to kill the decimal places, but it will not allow this. Also when you click on the format cell option you have to do so 3-6 times as it keeps going to the font subscreen rather than the main screen. Otherwise the program works fine and displays everything designed in an earlier version of Excell without problems |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
decimal point override does not work | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
Format a worksheet to carry out all calculations to 2 decimal plac | Excel Discussion (Misc queries) | |||
Text to Numeric format | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |