| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Accounting format returns a - for zero other cells show 0.0 Why?
Cell format set to accounting returns a - for zero. The sample box also shows
-. On other cells with accounting format 0.00 is returned and the sample box shows 0.00. How can the sample be changed to give me a consistent format? Many thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Accounting format returns a - for zero other cells show 0.0 Why?
Maybe ur cell which shows 0.00 is not zero, but value close to zero having
some decimal value at 3th or further decimal place, e.g. 0.001, 0.00000099 or so. Did you try to round on two decimal places first? "The Bookeeper" wrote: Cell format set to accounting returns a - for zero. The sample box also shows -. On other cells with accounting format 0.00 is returned and the sample box shows 0.00. How can the sample be changed to give me a consistent format? Many thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Accounting format returns a - for zero other cells show 0.0 Wh
"Alojz" wrote: Maybe ur cell which shows 0.00 is not zero, but value close to zero having some decimal value at 3th or further decimal place, e.g. 0.001, 0.00000099 or so. Did you try to round on two decimal places first? "The Bookeeper" wrote: Thanks. Sorted Cell format set to accounting returns a - for zero. The sample box also shows -. On other cells with accounting format 0.00 is returned and the sample box shows 0.00. How can the sample be changed to give me a consistent format? Many thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Accounting format returns a - for zero other cells show 0.0 Wh
you are welcome
"The Bookeeper" wrote: "Alojz" wrote: Maybe ur cell which shows 0.00 is not zero, but value close to zero having some decimal value at 3th or further decimal place, e.g. 0.001, 0.00000099 or so. Did you try to round on two decimal places first? "The Bookeeper" wrote: Thanks. Sorted Cell format set to accounting returns a - for zero. The sample box also shows -. On other cells with accounting format 0.00 is returned and the sample box shows 0.00. How can the sample be changed to give me a consistent format? Many thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Accounting format returns a - for zero other cells show 0.0 Why?
A value of 0.004 will display as 0.00 in accounting format. It means your
answer is close to zero, but it's not zero. If you want this displayed as -, the round the result, as in: =round(yourformula,2) Regards, Fred. "The Bookeeper" <The wrote in message ... Cell format set to accounting returns a - for zero. The sample box also shows -. On other cells with accounting format 0.00 is returned and the sample box shows 0.00. How can the sample be changed to give me a consistent format? Many thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Accounting format returns a - for zero other cells show 0.0 Wh
many thanks, formula worked gr8
"Fred Smith" wrote: A value of 0.004 will display as 0.00 in accounting format. It means your answer is close to zero, but it's not zero. If you want this displayed as -, the round the result, as in: =round(yourformula,2) Regards, Fred. "The Bookeeper" <The wrote in message ... Cell format set to accounting returns a - for zero. The sample box also shows -. On other cells with accounting format 0.00 is returned and the sample box shows 0.00. How can the sample be changed to give me a consistent format? Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show zero in Accounting format ? | Excel Worksheet Functions | |||
| Format Cells - Accounting - Discrepancy? | Excel Discussion (Misc queries) | |||
| Accounting Category Display does not show the correct format/outpu | New Users to Excel | |||
| accounting format for zero show 0.00 in one cell "-" in another | Excel Discussion (Misc queries) | |||
| How do I get brackets in format cells accounting? | Excel Discussion (Misc queries) | |||
Hybrid Mode
