Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Format Cells as Currency (XP)

    Hi

    I have a Table with a Column of Cells that I'd like to be formatted as currency, but after checking the HELP Files, I can't find out how this can be done.

    In WordPerfect, there's a special Table Menu Item (Numeric Format), but I can't find a corresponding Menu Item in Word. I see that there's a Formula Menu Item, which has a 'Number Format', but you can't simply select this without adding a Formula or Paste Function.

    I'm hoping I'm just stupid and that there is a way to Format Table Cells as currency, but that I'm just missing it.

    Any help or advice would be appreicated.

    Thanks in advance.

    Brian

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Format Cells as Currency (XP)

    Word is not Excel. If you enter something in a table cell, it's text, even if it looks like a number.
    Word has limited formula options in tables, but if you really want to do Excel-like things in Word, I suggest that create and format the table in Excel, then copy it to Word.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Format Cells as Currency (XP)

    OK. Thanks for clarifying that.

    I just thought that b/c WordPerfect could do it, Word would have been able to do it too.

    I guess that's another one up for WordPerfect! [img]/forums/images/smilies/smile.gif[/img]

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format Cells as Currency (XP)

    There is one thing that you can do with Find/Replace & with decimal tabs. IF your numbers are all with 2 decimals & you want to line them up on the decimal point & place a dollar sign in front, you can do this:

    1. Select your table column.
    2. Press Ctrl+H to bring up the Replace dialog box.
    3. Click "More" & then "Use wildcards".
    4. Find: ([0-9]{1,}.[0-9]{2})
    Replace: $ 1

    This finds any number of digits 0-9, followed by a period, followed by 2 numbers. When you click "Replace all", it's replaced by a $, a space, & then itself.

    5. With the column still selected, click on the very left of the ruler until the tab marker looks like an upside down T with a dot. That's the decimal tab.
    6. Then click on the ruler where you want the decimal point to line up. Word will line up the numbers without you manually having to put a tab in each cell.

    Cheers,

  5. #5
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Format Cells as Currency (XP)

    Thanks Phil.

    I'm used to Word making me jump through hoops, as opposed to WordPerfect, where everything is simple, but that's just a little too much jumping for me! As an alternative workaround, we copied the column into Excel, used Excel's currency format, then copied the column back into Word.

    I do genuinely appreciate the effort you put into posting that reply. Thanks muchly. [img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •