Solved

Zero Number Formatting In Word 2003

Posted on 2011-10-06
175 Views
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.

0
Question by:Eirman

LVL 5

Expert Comment

Try this, it worked for me:

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

0

LVL 23

Author Comment

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

LVL 23

Author Comment

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

LVL 23

Author Comment

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

LVL 5

Accepted Solution

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

LVL 23

Author Comment

€,0.00;-€,0.00;

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

LVL 5

Expert Comment

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

Featured Post

Introduction Authors who set out to write any sort of lengthy piece for online submission—be it a long question or comment on a technical form, an article, or a substantial blog entry—often find it useful to work up a draft in an editor other t…
It is often necessary in this forum and others to illustrate Word fields as text with the field delimiters replaced with the curly brackets that the delimiters resemble when field codes are being displayed on the document. This means that the text c…
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.