Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Formating a cell so that it contains only numbers
I have created a table on Word 2004 for Mac and I need to make a row of cells
that can contain only numbers. I don't need any formulas, just a number containing two decimal places. Eg. If I type 10 into the cell, I want it to automatically change it to 10.00. Does this make sense? In Excel you go to "Format - Cells... - Number" and it gives you the option to place the amount of decimal points. Is this even possible in Word? I can't seem to find anything in the help files €“ it just tells me how to create formulas with decimal places. |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Formating a cell so that it contains only numbers
Hi sugarmac,
The only ways to get that functionality in Word are to: a) set the table up with formfields for numeric data entry, and protect the document for forms, or b) embed an Excel workbook in the document with the appropriate cell formatting. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "sugarmac" wrote in message ... I have created a table on Word 2004 for Mac and I need to make a row of cells that can contain only numbers. I don't need any formulas, just a number containing two decimal places. Eg. If I type 10 into the cell, I want it to automatically change it to 10.00. Does this make sense? In Excel you go to "Format - Cells... - Number" and it gives you the option to place the amount of decimal points. Is this even possible in Word? I can't seem to find anything in the help files €“ it just tells me how to create formulas with decimal places. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Formating a cell so that it contains only numbers
Thanks, I'll give b) a try!
"macropod" wrote: Hi sugarmac, The only ways to get that functionality in Word are to: a) set the table up with formfields for numeric data entry, and protect the document for forms, or b) embed an Excel workbook in the document with the appropriate cell formatting. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "sugarmac" wrote in message ... I have created a table on Word 2004 for Mac and I need to make a row of cells that can contain only numbers. I don't need any formulas, just a number containing two decimal places. Eg. If I type 10 into the cell, I want it to automatically change it to 10.00. Does this make sense? In Excel you go to "Format - Cells... - Number" and it gives you the option to place the amount of decimal points. Is this even possible in Word? I can't seem to find anything in the help files €“ it just tells me how to create formulas with decimal places. |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Formating a cell so that it contains only numbers
Hi macropod
What about numeric picture (\#) field switches, do those work without formulas? Thanks for any feedback! "macropod" wrote: Hi sugarmac, The only ways to get that functionality in Word are to: a) set the table up with formfields for numeric data entry, and protect the document for forms, or b) embed an Excel workbook in the document with the appropriate cell formatting. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "sugarmac" wrote in message ... I have created a table on Word 2004 for Mac and I need to make a row of cells that can contain only numbers. I don't need any formulas, just a number containing two decimal places. Eg. If I type 10 into the cell, I want it to automatically change it to 10.00. Does this make sense? In Excel you go to "Format - Cells... - Number" and it gives you the option to place the amount of decimal points. Is this even possible in Word? I can't seem to find anything in the help files €“ it just tells me how to create formulas with decimal places. |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Formating a cell so that it contains only numbers
"sugarmac" wrote:
Hi macropod What about numeric picture (\#) field switches, do those work without formulas? The key word here is "field". They only work with fields. It would a lot more trouble to insert fields with the numerical values you want than just type something like "10.00." As macropod wrote, the only way fields will work automatically (I.e. by the user just typing in the field without the field being replaced by what is being typed) is to work with a protected form. |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Formating a cell so that it contains only numbers
OK. Thanks.
"Jean-Guy Marcil" wrote: "sugarmac" wrote: Hi macropod What about numeric picture (\#) field switches, do those work without formulas? The key word here is "field". They only work with fields. It would a lot more trouble to insert fields with the numerical values you want than just type something like "10.00." As macropod wrote, the only way fields will work automatically (I.e. by the user just typing in the field without the field being replaced by what is being typed) is to work with a protected form. |
#7
Posted to microsoft.public.word.tables
|
|||
|
|||
Formating a cell so that it contains only numbers
I guess you could use a macro attached to a keyboard shortcut eg
Sub InsertNumberAsField() Dim sNum As String sNum = InputBox("Enter number") If sNum = "" Then Exit Sub sNum = sNum & " \# ,0.00" With Selection.Fields .Add Range:=Selection.Range, Type:=wdFieldEmpty, _ Text:="= " & sNum, _ PreserveFormatting:=False .Update End With ActiveWindow.View.ShowFieldCodes = False End Sub but it is simpler just to type the number correctly. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org sugarmac wrote: OK. Thanks. "Jean-Guy Marcil" wrote: "sugarmac" wrote: Hi macropod What about numeric picture (\#) field switches, do those work without formulas? The key word here is "field". They only work with fields. It would a lot more trouble to insert fields with the numerical values you want than just type something like "10.00." As macropod wrote, the only way fields will work automatically (I.e. by the user just typing in the field without the field being replaced by what is being typed) is to work with a protected form. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I MAIL MERGE AN EXCEL CELL WITH CURRENCY FORMATING . | Mailmerge | |||
how do I set up number formating in a cell of a table, ie, $1.00? | Tables | |||
Formating, merging, drawing lines, page numbers | Microsoft Word Help | |||
Formating Based On Page Numbers | Microsoft Word Help | |||
Formating Mail Merge of 10 digit numbers to have parenthasis+dash | Mailmerge |