Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Charitychic Charitychic is offline
external usenet poster
 
Posts: 1
Default Word Table-Automatically show a $ in the money column?

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   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Word Table-Automatically show a $ in the money column?

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   Report Post  
Posted to microsoft.public.word.tables
Stefan Blom Stefan Blom is offline
external usenet poster
 
Posts: 8,428
Default Word Table-Automatically show a $ in the money column?

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?







  #4   Report Post  
Posted to microsoft.public.word.tables
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Word Table-Automatically show a $ in the money column?

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?



  #5   Report Post  
Platudd Platudd is offline
Junior Member
 
Posts: 1
Default

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.


  #6   Report Post  
watson watson is offline
Junior Member
 
Posts: 1
Default

Thank you everyone for listening to your questions, and thank you very much for your answers. https://stickmanhook.io
  #7   Report Post  
gmmelissa gmmelissa is offline
Junior Member
 
Posts: 4
Default

Each play is a challenge and you will feel the victor's taste. Join the fun game completely free and without ads skribblio
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I put dates in a table column automatically (w/o typing)? jredoutey Tables 2 May 10th 23 02:48 PM
Automatically totaling a column in a table Samantha Tables 7 July 16th 07 11:50 PM
In a Word table, how can you total up a column of figures (money)? Mikelis Tables 3 June 5th 07 05:27 AM
Table Column Widths Automatically Resize The Merg Tables 1 April 11th 06 09:25 AM
Table--A new column will not show all text even though I have wid. Kendall Tables 5 March 7th 05 12:29 PM


All times are GMT +1. The time now is 08:06 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"