in the same spreadsheet sometimes the money amount is correct ex: $15.75 and sometimes is rounds into tenths Ex: 15 7400000000000000000
I've tried to change the format of the whole column and the one cell. nothing seems to work. any suggestions that I'm just missing?
Last edited by dusty88881; 06-19-2013 at 12:45 PM.
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
in a separate column
=round(a1,2)
copy down
Copy this column -- paste special -- values (in orignal column)
Life's a spreadsheet, Excel!
Say thanks, Click *
are the b2 values identical? Test with =exact()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks