Formatting numbers in a Word table

J

John West

I wish to enter a decimal number with more than 2
significant digits in a Word table so that the whole
number is used for a calculation (no problem there) but so
that only two significant digits are displayed (with or
without rounding). I know that it's easy in Excel but
this document is a Word document. Any ideas?
 
D

Doug Robbins - Word MVP

Hi John,

Insert an Excel "table" instead of a Word table.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 
M

macropod

Hi John,

Although Word can't do exactly what you want, you can
simulate it.

In the cell in which you want to use more than two
decimals, insert a field like:
{=1.234567890 #\ #.000000000000}
where your number is 1.234567890 and you've used as many
0s after the decimal point as you need for precision (15
is about the max).

With the numeric picture switch, select all of the 0s to
the right of the decimal point that you don't want
printed, and format their colour to white (or whatever
background colour you're using).

Press F9 to update.

Now insert a decimal tab to position the decimal point
where you want it to be and move the right margin
sufficiently far to the right to allow the decimal tab to
take effect.

On screen, you'll still see some of the unwanted
charatcers, but these shouldn't show in print preview or
on paper.

Cheers
PS: Remove NO.SPAM from the above before replying.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top