| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet is set up for 2 decimal places but format changes
I have worksheet that I set up to be 2 decimal places using Accounting
format. I changed one column to reflect dates which is not a problem. What is a problem is that in one of the cells where I want a number, the result of putting in 300/3750 (I'm trying to figure the sales tax rate) I get 2/25 instead of .08. This is excel 2000. How can I get this to display properly without my having to override every time? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format issues with decimal places | Excel Discussion (Misc queries) | |||
| decimal places in format cell | Excel Discussion (Misc queries) | |||
| Can you set to default the # of decimal places in Format Cells? | Setting up and Configuration of Excel | |||
| Formula for: Format Decimal places? | Excel Discussion (Misc queries) | |||
| My numbers format as a number with two decimal places. | Excel Discussion (Misc queries) | |||
Threaded Mode
