#1
|
|||
|
|||
How do I create currency cells in a Word Table
I need small table in Word. How do I convert 2 columns to currency cells. This will automatically insert the currency decimal separation points in the currency?
|
#2
|
||||
|
||||
Word tables don't have any automatic cell formats. If you want a currency format, you have to apply it to each cell yourself. Other than typing the currency format manually, you could use a macro to format the cells, perhaps attached to a content control on-exit macro (but only if you use content controls) or a macrobutton field, or if you use formfields in a document with forms protection. See, for example: https://www.msofficeforums.com/16726-post2.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Appreciation
Thank you for the help. Thought I could make my life a bit easier, but no chance of that
|
#4
|
||||
|
||||
If it suits your purposes you could embed an Excel worksheet in the document. That will give you access to all of Excel's functionality.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Create a macro. It takes a little bit of effort, but then it will be super super easy.
I can't take the credit for this macro, it comes from here: http://ask.brothersoft.com/how-do-i-...le-113359.html
Code:
Sub CurrencyTableFormat() ' ' CurrencyTableFormat Macro ' ' Dim tCell As Word.Cell Dim tRange As Range If Selection.Type = wdSelectionIP Or Not Selection.Information(wdWithInTable) Then MsgBox "Select numerical values in tables cells before running this macro.", , "Error" Exit Sub End If For Each tCell In Selection.Cells Set tRange = tCell.Range tRange.End = tRange.End - 1 With tRange If IsNumeric(tRange) Then .Text = FormatCurrency(Expression:=.Text) End If On Error Goto Skip Skip: End With Next tCell End Sub
Last edited by macropod; 06-13-2014 at 03:46 PM. Reason: Added code tags & formatting |
#6
|
||||
|
||||
kate: If you read posts 2 & 3 in this thread, you will see that a macro was suggested (and a link to one provided), but the response was "Thought I could make my life a bit easier, but no chance of that." That makes it fairly obvious a macro such as you've posted isn't a solution in this case, apart from which, it doesn't address the underlying issue of the OP wanting the formatting to occur as the data are entered. The only ways of achieving that are as outlined in posts 2 & 4.
PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Hey Paul,
Yes I did read through but not everyone is familiar with macros and how to use them. It's easy to assume that they're hard to manipulate and won't make life easier. But sometimes, when it's spelled out like that, it doesn't look as difficult. IMO, more info is never a bad thing And I don't usually use the code tags for short things like that because I find it cumbersome and annoying to read. It's a personal preference for short codes like that. But I appreciate the advice! - K |
#8
|
||||
|
||||
Quote:
One very good reason for using code tags is that they preserve the code layout. If you look at the code you posted, all the structure has gone. You may not care about that, but most people find structured code much easier to understand. If it was just one or two lines, fair enough, but not for whole subs - and it only takes a few seconds to do. Please keep that in mind for future posts.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
I would like to format cells in a table in Microsoft word to automatically show as currency. .
ONLINE CASINO AUSTRALIA Last edited by leonardmonk; 06-17-2014 at 05:12 AM. |
#10
|
||||
|
||||
Have you read the previous discussion?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#11
|
|||
|
|||
Yikes help!
Is there an update on this yet? 2019 version. or How to do multiplication inside a cell like you can do on excel?
|
#12
|
||||
|
||||
Nothing has changed in how Word tables work. If you don't want to embed an Excel worksheet in the document, see my Microsoft Word Field Maths Tutorial, at:
Microsoft Word Field Maths Tutorial
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#13
|
|||
|
|||
I open the file in LibreOffice and format the cells tehre, very easy to do.
|
#14
|
||||
|
||||
This is hardly a relevant response to a Word problem that was answered over seven years ago...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Weird: 2 cells with data in Word 2010 table will not print! | Mendopaul | Word | 8 | 03-23-2014 02:18 PM |
Word 2007 Table - Shift Cells | INDYBUG | Word Tables | 1 | 09-29-2013 05:47 PM |
Word VBA: add textboxs in table cells? | tinfanide | Word VBA | 12 | 02-09-2012 12:05 AM |
Set range for merged Word table cells? | tinfanide | Word VBA | 1 | 02-06-2012 05:57 AM |
Formatting Cells for Currency and Accounting | Sparetyme | Excel | 1 | 07-11-2010 01:26 PM |