Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Word tables: how do you format numbers?
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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. |
#7
|
|||
|
|||
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. |
#8
|
|||
|
|||
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. |
#9
|
|||
|
|||
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. |
#10
|
|||
|
|||
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. |
#11
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I divide a page into three sections? | Microsoft Word Help | |||
Wordperfect Office 2000 conversion to Word 2003 | New Users | |||
WordPerfect - copying formatting | Page Layout | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
macro in word | Microsoft Word Help |