How do I remove "currency" formatting from a table cell in wordperfect 12?

Posted on 2009-02-16
Last Modified: 2013-12-26
How do I remove "currency" formatting from an excel file I imported as a table into wordperfect 12.  I want the formatting to be integer with 2 places after the decimal.  The formatting refuses to change for me beginning with row 64.  Help!
Question by:ibfluffy
    LVL 31

    Assisted Solution

    I take it you have highlighted the whole table/column/row and used the Cell formatting options to remove the currency symbol.  Hmm, having imported this from an outside source and Row 64 being a milestone in binary terms, you may have hit on a limitation in WordPerfect's formatting ability.  The most straightforward way I can think of to resolve this would be to edit the spreadsheet and then re-import it.
    LVL 31

    Accepted Solution

    Do you have the most up-to-date patches for this version of WordPerfect? (SP3)

    Author Comment

    It wasn't every cell at line 64, only column E so the binary answer didn't help.  I did NOT have the most up-to-date Releases but installing them did not help.  Then I thought to delete the entire column in question, add it back in and voila! no more currency formatting issues.  Thanx for trying.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
    This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
    The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now