MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 278|Reply: 9

Formatting Text in a Table

[Copy link]

1

Topics

5

Posts

15

Integral

Member

Rank: 2

Integral
15
Post on 2-6-2017 21:01:29 | All posts |Read mode
Hi,
Is there a way I can format a cell to show as currency?
e.g. I enter 10000 and it displays as $10,000.00
Thanks in advance,
Paul.
Reply

Props Report

2

Topics

22

Posts

62

Integral

Member

Rank: 2

Integral
62
Post on 2-7-2017 00:26:09 | All posts



yes
in the home tab click number and select currency - that format should be one of the default options
or, if for some reason you want to customise it, select custom and type this in the forma box:
$#,##0.00
Reply Support Opposition

Props Report

2

Topics

22

Posts

62

Integral

Member

Rank: 2

Integral
62
Post on 2-7-2017 01:59:58 | All posts



yes
in the home tab click number and select currency - that format should be one of the default options
or, if for some reason you want to customise it, select custom and type this in the forma box:
$#,##0.00




Reply Support Opposition

Props Report

1

Topics

5

Posts

15

Integral

Member

Rank: 2

Integral
15
 Author| Post on 2-7-2017 03:26:17 | All posts



Thanks for your reply.
This is a table in Word I'm talking about, not Excel.
There is no number option in the home tab...




Reply Support Opposition

Props Report

6

Topics

351

Posts

832

Integral

Lord

Rank: 4

Integral
832
Post on 2-7-2017 04:25:47 | All posts



Hi Ed,
My wife, the*Word Expert says you can do it using fields, but it isn't worth the effort.  Perhaps you should do the table in Excel and copy it into your word doc.











Reply Support Opposition

Props Report

1

Topics

5

Posts

15

Integral

Member

Rank: 2

Integral
15
 Author| Post on 2-7-2017 05:59:22 | All posts



Thanks Marvin. Think that's the way to go.
Such a simple thing, it's a wonder it's made so hard.
Reply Support Opposition

Props Report

1

Topics

5

Posts

15

Integral

Member

Rank: 2

Integral
15
 Author| Post on 2-7-2017 06:46:29 | All posts



Thanks Marvin. Think that's the way to go.
Such a simple thing, it's a wonder it's made so hard.




Reply Support Opposition

Props Report

2

Topics

188

Posts

466

Integral

Conqueror

Rank: 3Rank: 3

Integral
466
Post on 2-7-2017 07:55:03 | All posts



You can indeed do it using field coding, or you could use a macro. The following macro formats part or all of a table in a two-decimal format, with or without a $ symbol.
Sub DecimalFormatter()
Dim Rslt, RsDz, oCel As Cell, Rng As Range
If Selection.Information(wdWithInTable) = False Then
  MsgBox Cannot run outside a table, vbExclamation, Decimal Formatter
  Exit Sub
End If
Rslt = MsgBox(Format the whole table?, vbYesNoCancel, Decimal Formatter)
If Rslt = vbCancel Then Exit Sub
RsDz = MsgBox(Apply currency formatting?, vbYesNo, Decimal Formatter)
If RsDz = vbNo Then RsDz =
If RsDz = vbYes Then RsDz = $
If Rslt = vbNo Then
  For Each oCel In Selection.Cells
    Set Rng = oCel.Range
    With Rng
    .End = .End - 1
      If IsNumeric(.Text) Then .Text = Format(.Text, RsDz  #,##0.00)
    End With
  Next
End If
If Rslt = vbYes Then
  For Each oCel In Selection.Tables(1).Range.Cells
    Set Rng = oCel.Range
    With Rng
    .End = .End - 1
      If IsNumeric(.Text) Then .Text = Format(.Text, RsDz  #,##0.00)
    End With
  Next
End If
End SubFor PC macro installation  usage instructions, see: http://www.gmayor.com/installing_macro.htm
Another approach would be to embed an Excel worksheet in the Word document. That gives your table full Excel functionality.











Reply Support Opposition

Props Report

1

Topics

5

Posts

15

Integral

Member

Rank: 2

Integral
15
 Author| Post on 2-7-2017 08:21:43 | All posts



Thanks Paul. I'll have a play with it.




Reply Support Opposition

Props Report

6

Topics

351

Posts

832

Integral

Lord

Rank: 4

Integral
832
Post on 2-7-2017 09:45:39 | All posts



Hi Ed,
Take a look at this*site to answer your question.
http://www.carolscorneroffice.com/ho...rency-in-word/
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:24 , Processed in 0.316834 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!