A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Word Table-Automatically show a $ in the money column?



 
 
Thread Tools Display Modes
  #1  
Old July 2nd 08, 01:56 PM posted to microsoft.public.word.tables
Charitychic
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?
Ads
  #2  
Old July 2nd 08, 02:16 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 33,626
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  
Old July 2nd 08, 02:20 PM posted to microsoft.public.word.tables
Stefan Blom
external usenet poster
 
Posts: 8,429
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  
Old July 2nd 08, 03:06 PM posted to microsoft.public.word.tables
Graham Mayor
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  
Old February 11th 21, 08:58 AM
Platudd Platudd is offline
Junior Member
 
First recorded activity by WordBanter: Feb 2021
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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
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 1 January 14th 08 12:14 AM
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 03:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.