| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Values
For some reason I can not get decimal values to show up on my spread sheet.
For instance, if my A1 Value is 2050, I type in Quotient (A1,12), it will read $170.00. I have it set to currency, I've tried checking and unchecking precision as displayed. I've tried making the cell huge to accomodate for any potential smooshing, I've tried adding dozens of extra decimal places, and it never calculates the change. I tried changing it to accounting too, and it still doesn't work. What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find records with values more then 2 decimal places. | Excel Discussion (Misc queries) | |||
| Hiding certain decimal values | Excel Worksheet Functions | |||
| Summing decimal values to time | New Users to Excel | |||
| Finding Values With more than 2 decimal Places | Excel Discussion (Misc queries) | |||
| SUBTRACTING TIME VALUES INSTEAD OF DECIMAL!! | Excel Discussion (Misc queries) | |||
Threaded Mode
