Word tables: how do you format numbers?

[Steel]

Is there anyway to format numbers in a Word table? For example, I would like
to enter 9876543 and have it automatically convert to $9,876,543.00 as you
can do in Excel. I realize you can do this in the function cell, but I can't
figure out how to do it in other cells.

 

[Graham Mayor]

Create the table in Excel and Insert it as a link into Word, which does not
have the ability to do this as you require.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Stefan Blom]

No, Word doesn't offer a way to apply a numeric format to a table
cell, unfortunately. If you have Excel, you can embed a spreadsheet
into the Word document, and take advantage of its number formatting
capabilities.

 

[Josh]

I know there is no way on the format options, but can't you programatically
format the table?

 

[Stefan Blom]

Maybe there is. The best way to find out is to ask in a programming
newsgroup such as microsoft.public.word.vba.general.

 

[Stefan Blom]

I just noticed that the question has been asked in
microsoft.public.word.vba.general, in the thread titled "Table number
formating". There are no responses yet, though.

 

[Allabout]

You can put form fields in your table and format these as numbers, setting
the format to $#,##0.00;($#,##0.00) when you protect the form the user will
only be able to fill in the form fields and they will format as they are
completed.

Andrea Jones

 

[Stefan Blom]

Well, it is correct that a protected form allows you to specify a
numeric format. What complicates matters is that the OP also wants to
calculate results in cells (using the SUM formula) and this wouldn't
work in a protected document. Of course, it may be possible to use the
techniques described in the article at
http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm, but this
might be too much work (it certainly would be to me!) to get formatted
numbers in table cells.

 

[Suzanne S. Barnhill]

But the OP can use a calculation form field.

 

[Stefan Blom]

That's true! I didn't think of that. You can tell I don't work with
protected documents that much...

Thank you for pointing out my error!

 

[Suzanne S. Barnhill]

I don't use them at all! I just answer questions about them. <g>