Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 03-14-2019, 05:53 AM
Marcia's Avatar
Marcia Marcia is offline excel macro returning the wrong value Windows 7 32bit excel macro returning the wrong value Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by Pecoflyer View Post
Thank you for this Pecoflyer. In the 2017 annual financial report that I prepared for our agency, the person in charge of consolidating all reports accused me of "force balancing" the accounts because when she manually entered all the data there was a .01 difference. I used the ROUND function in calculating the depreciation expenses but there's still the .01 problem. I will try the the Precision as Displayed option come year -end.
Reply With Quote
 

Tags
cell value, excel macro



Similar Threads
Thread Thread Starter Forum Replies Last Post
excel macro returning the wrong value Table column width wrong - unless macro paused!? Kebap Word VBA 7 09-21-2018 03:14 PM
Returning text, date, time, location from one Excel sheet to another dave57 Excel 17 06-15-2017 10:45 AM
excel macro returning the wrong value Excel colums are wrong way around SteveL Excel 1 05-06-2015 02:09 AM
excel macro returning the wrong value Macro operates on wrong document window marceepoo Word VBA 1 12-20-2012 03:12 PM
need macro for quiz (?) repeat of wrong answers with shuffle braveshark PowerPoint 0 10-02-2012 06:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft