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.

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Steel wrote:
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.

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.

--
Stefan Blom


"Steel" wrote in message
...
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.

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

"Steel" wrote:

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.

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


"Josh" wrote in message
...
I know there is no way on the format options, but can't you
programatically
format the table?

"Steel" wrote:

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.

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.

--
Stefan Blom


"Stefan Blom" wrote in message
...
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


"Josh" wrote in message
...
I know there is no way on the format options, but can't you
programatically
format the table?

"Steel" wrote:

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.

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

"Josh" wrote in message
...
I know there is no way on the format options, but can't you
programatically
format the table?

"Steel" wrote:

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.

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/...ProtectDoc.htm, but this
might be too much work (it certainly would be to me!) to get formatted
numbers in table cells.

--
Stefan Blom


"Allabout" wrote in message
...
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

"Josh" wrote in message
...
I know there is no way on the format options, but can't you
programatically
format the table?

"Steel" wrote:

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.

But the OP can use a calculation form field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Stefan Blom" wrote in message
...
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/...ProtectDoc.htm, but this
might be too much work (it certainly would be to me!) to get formatted
numbers in table cells.

--
Stefan Blom


"Allabout" wrote in message
...
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

"Josh" wrote in message
...
I know there is no way on the format options, but can't you
programatically
format the table?

"Steel" wrote:

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.

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!

--
Stefan Blom


"Suzanne S. Barnhill" wrote in message
...
But the OP can use a calculation form field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"Stefan Blom" wrote in message
...
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/...ProtectDoc.htm, but
this
might be too much work (it certainly would be to me!) to get
formatted
numbers in table cells.

--
Stefan Blom


"Allabout" wrote in message
...
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

"Josh" wrote in message
...
I know there is no way on the format options, but can't you
programatically
format the table?

"Steel" wrote:

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.

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Stefan Blom" wrote in message
...
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!

--
Stefan Blom


"Suzanne S. Barnhill" wrote in message
...
But the OP can use a calculation form field.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"Stefan Blom" wrote in message
...
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/...ProtectDoc.htm, but
this
might be too much work (it certainly would be to me!) to get
formatted
numbers in table cells.

--
Stefan Blom


"Allabout" wrote in message
...
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

"Josh" wrote in message
...
I know there is no way on the format options, but can't you
programatically
format the table?

"Steel" wrote:

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.