Results 1 to 5 of 5

need a bit of help.....

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2005
    Posts
    17

    Unhappy need a bit of help.....

    I have generated a form in excel that shows money amounts. yet i want two colums that separates the dollar amount from cents. I have for example colum H as the dollar amount and colum I as the cent amounts. Now i have tried Format Cell to set it up but it doesnt work. for example i tried the custom format for the dollar amount and it rounds it. and if there's an amount of 1108.83 the cell will show 1109. so it does not show the true value amount. i also tried the same approach with the =RIGHT(H1,2) but with the left and Mid but still didnt work, because i would have to enter the same amount of caracters each time. as far as the cents, there is no problems because i did the =RIGHT(H1,2) function. it will on show the cent amounts.

    so is there another way to set it up?
    Please yall.... let me know....
    Last edited by Joe@excel; 11-23-2005 at 12:03 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1