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.

LVL 24
EirmanChief Operations ManagerAsked:
Who is Participating?
 
MAdSConnect With a Mentor Commented:
I haven't noticed the extra blanks for small numbers. Format bellow should do what you want, which is one should generally expect (looks a litle weird to me but it works):

€,0.00;-€,0.00;

Formating goes like that:
"." means you want decimal separator
"," means you want thousands separator
"0" means a digit from your number
"#" means non-zero digit or nothing for zero (now looks like it is space instead of nothing)
any other character is printed as it is
0
 
MAdSCommented:
Try this, it worked for me:

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

0
 
EirmanChief Operations ManagerAuthor Commented:
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
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
EirmanChief Operations ManagerAuthor Commented:
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

0
 
EirmanChief Operations ManagerAuthor Commented:
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)
0
 
EirmanChief Operations ManagerAuthor Commented:
€,0.00;-€,0.00;

Short and simple ...... and it works!
many thanks
0
 
MAdSCommented:
I forgot some meaningful characters in formating:
"-" before or after means "-" prints for negative numbers
"(" ")" before AND after means negative numbers print between "(" and ")"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.