ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> EXPORTING FINANCIALS
http://www.istechforum.com/YaBB.pl?num=1326825162

Message started by carolg on 01/17/12 at 11:32:42

Title: EXPORTING FINANCIALS
Post by carolg on 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.

Title: Re: EXPORTING FINANCIALS
Post by Kelloggs on 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

:P

Kelloggs