Exporting to excel using integrated reporting for sage 50

Exporting to excel using integrated reporting...

Didn't find your answer?

Hi all

I'm just wondering if there is a way to format the monthly NL report from sage when exported into excel so that it doesn't have the DR and CR in front of the figures. I cant use Vlookup to get the figures from this report into my monthly accounts/ budget comparisons.

Many thanks

Susanne

Replies (3)

Please login or register to join the discussion.

avatar
By Alan1
23rd May 2012 15:08

Never used sage - but

If you have say DR12 and you want 12, then you could try highlighting the cells, use ctr h (or edit replace), type DR in find box and leave replace as blank. End result will be the number.

Hope it helps.

 

Thanks (0)
avatar
By Richard Willis
25th May 2012 13:15

As the DR & CR are consistent

and have a space after them I believe, do

=RIGHT(cellref,LEN(cellref)-3)

You may need to do =VALUE(RIGHT(cellref,LEN(cellref)-3) ) to get a numeric answer.

Thanks (0)
avatar
By Richard Willis
25th May 2012 13:22

OR...

 =IF(LEFT(cellref,2)="CR",-VALUE(RIGHT(cellref,LEN(cellref)-3)) ,VALUE(RIGHT(cellref,LEN(cellref)-3)) )

Check the brackets but this will give you DRs and CRs as + & -

Thanks (0)