Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
In Word, I have made a table with names of donors, their address, and the
amounts they donated. One column is money amounts...I would like to just type in say, 25 and have it come out as $25. How do I get the $ in there automatically? |
#2
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
There's really no simple way to do this in Word except by embedding an Excel
sheet. The only way to create a "number mask" in Word is through field switches, and that requires that you be using a field. If the money amount was a form field, you could define the format, but you would have to protect the document for forms. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Charitychic" wrote in message ... In Word, I have made a table with names of donors, their address, and the amounts they donated. One column is money amounts...I would like to just type in say, 25 and have it come out as $25. How do I get the $ in there automatically? |
#3
![]() |
|||
|
|||
![]()
Thank you everyone for listening to your questions, and thank you very much for your answers. https://stickmanhook.io
|
#5
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
Word doesn't allow you to specify numeric formats for table cell contents.
What you can do is make use of text form fields, whose formats can be specified, and then enable forms protection. For more on using forms in Word, see http://word.mvps.org/faqs/customizat...nTheBlanks.htm. The easiest approach, however, might be to embed an Excel spreadsheet in your Word document, using the spreadsheet instead of a Word table. -- Stefan Blom Microsoft Word MVP "Charitychic" wrote in message ... In Word, I have made a table with names of donors, their address, and the amounts they donated. One column is money amounts...I would like to just type in say, 25 and have it come out as $25. How do I get the $ in there automatically? |
#6
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
While Excel is possibly the simplest solution, it is posible to convert
numbers to fields using a macro. The following macro will format as currency the number in the table cell that contains the cursor. Attached to a keyboard shortcut it is as near 'automatic' as you will get. The resulting fields can be calculated, unlike plain text entries with currency symbols. Sub FormatNumberInCellAsField() Dim sNum As String With Selection .SelectCell .MoveLeft Unit:=wdCharacter, Count:=1, Extend:=wdExtend sNum = .Text If sNum = "" Then Exit Sub sNum = sNum & " \# ,$0.00" With .Fields .Add Range:=Selection.Range, Type:=wdFieldEmpty, _ Text:="= " & sNum, _ PreserveFormatting:=False .Update End With End With ActiveWindow.View.ShowFieldCodes = False End Sub http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Charitychic wrote: In Word, I have made a table with names of donors, their address, and the amounts they donated. One column is money amounts...I would like to just type in say, 25 and have it come out as $25. How do I get the $ in there automatically? |
#7
![]() |
|||
|
|||
![]()
Meistens finde ich mich leidenschaftlich für mein Lieblingshobby. Wenn Sie interessiert sind, dann ist hier die Seite https://online-roulett.at/spiele/sister-oz-wow/ mit den besten Online-Casino-Plattformen. Dieser wundervolle Ort macht mein Leben heller.
|
Reply |
Thread Tools | |
Display Modes | |
|
|