asked on

Zero Number Formatting In Word 2003

I'm trying to get zeros to show to show as blank when doing calculations in word 2003 tables

Please give the three formats that will yield the following outputs for a resuly of 2222 .....
€2,222.00
2,222.00
2,222
(With a blank for zero in all three cases)

The nearest I got was ...... "€,#.00;-€,#.00; "
It does give the blank for a zero value but the positive values are messed up.

MAdS

Try this, it worked for me:

€ #,##0.00;-€ #,##0.00;

Eirman

ASKER

We are getting there!

It works fine for results like €3,422.00

However, there is a problem with shorter results ....
€ 242.00 (two spaces after the € symbol)
€ 22.00 (three spaces after the € symbol)
€ 6.00 (four spaces after the € symbol)

and don't forget the final answer will be in three parts for the three formats

Also I cannot find any online info on how the formatting works.
All I really know that the ; is used to separate the formatting for Positive, Negative and zero results

Eirman

ASKER

This is how it works without the currency symbol so I have partially answed the question myself

#,##0.00;(#,##0.00); for 4,444.00
#,##0;#,##0; for 4,444

€4,444 and €4,444.00 are trickier .... full points if you can answer these

Eirman

ASKER

MAdS, I got rid of two spaces in your formatting and the errors have diminished

€ #,##0.00;-€ #,##0.00; ...... changed to €#,##0.00;-€#,##0.00;

€222.00 OKAY
€ 22.00 (two spaces after the € symbol)
€ 2.00 (three spaces after the € symbol)

ASKER CERTIFIED SOLUTION

MAdS

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Eirman

ASKER

€,0.00;-€,0.00;

Short and simple ...... and it works!
many thanks

MAdS

I forgot some meaningful characters in formating:
"-" before or after means "-" prints for negative numbers
"(" ")" before AND after means negative numbers print between "(" and ")"