ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   FIX FOR =N/A errors from EOMONTH (https://www.excelbanter.com/excel-worksheet-functions/257073-fix-%3Dn-errors-eomonth.html)

Drew[_5_]

FIX FOR =N/A errors from EOMONTH
 
I discovered that, after a lot of pain and frustration, a fix for a
file corrupted by this error is to simply open it in Open Office calc,
and save it down again.

I lost three hours figuring this out, but saved about 20 by not having
to redo all of the =n/a's.

Hope this helps someone.

Best,

Drew


All times are GMT +1. The time now is 06:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com