[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

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.

0
Eirman
Asked:
Eirman
  • 4
  • 3
1 Solution
 
MAdSCommented:
Try this, it worked for me:

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

0
 
EirmanAuthor 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
 
EirmanAuthor 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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
EirmanAuthor 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
 
MAdSCommented:
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
 
EirmanAuthor 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

Featured Post

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.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now