ISTech Support Forum - EXPORTING FINANCIALS

Welcome, Guest. Please Login.

	05/20/25 at 05:41:36 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Accounting

‹ Previous topic | Next topic ›

Pages: 1

EXPORTING FINANCIALS (Read 568 times)

carolg Full Member I Love EvoERP! Posts: 169 Gender:	EXPORTING FINANCIALS 01/17/12 at 11:32:42 Am I doing something wrong. I print financials to a txt file and then go in and save it as an excel file. But negative numbers are usually text and I have to go in and change each one. And then I have to go in and change totals to formulas if we want to make changes. This is especially true on budgets. And all the formatting is messed up.
Back to top	IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 784
Gender: male

Re: EXPORTING FINANCIALS
Reply #1 - 01/17/12 at 14:56:35

Create a Macro, it will convert <1,000.00> into -1,000.00

Sub Macro1()
' You must select the column before applaying the macro
   Selection.Replace What:="<", Replacement:="-", LookAt:=xlPart, _
   SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
   ReplaceFormat:=False
   Selection.Replace What:=">", Replacement:="", LookAt:=xlPart, _
   SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
   ReplaceFormat:=False
End Sub

Tongue

Kelloggs

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Accounting

‹ Previous topic | Next topic ›