$ sign and numbers after decimal

5 pts.
Tags:
Microsoft Excel
microsoft excel functions
One of my columns is for a $ amount that never changes for that particular person. Recently, I wrapped the text to print out a readable copy. For some reason I lost all the $ signs in that column. Also, when changing an amount such as $176.37, the .37 will not stay.  The $ sign is true for all 129 entries, but the .37 is only true for a recent entry.

Software/Hardware used:
MAC 10.6.8 Microsoft Excel 2008

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TheRealRaven
    A link-only answer should be deleted; links can go stale quickly. One that seems to go to an ad should be deleted immediately.
    18,995 pointsBadges:
    report
  • ToddN2000
    What is the current formatting of the column in Excel? Where are you wrapping the text? Is there other data in this column besides the dollar amount? Where did the data come from, was it imported and if so by what means ?
    42,790 pointsBadges:
    report
  • Subhendu Sen
    Have you checked for regional settings/ check for column formatting.
    44,060 pointsBadges:
    report
  • azohawk

    Is the column or cell set for no decimals? That would cause rounding and account for why you do not see the .37.

    1,780 pointsBadges:
    report
  • ToddN2000
    Check the current formatting on the cell. If this is new data then it might be that the old data was the only thing formatted and not the entire column. It might be a good idea to format the entire column if new data will be coming in. Check to see the column is formatted as currency or number and what the number of decimals is set to.

    42,790 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following