Missing Open Bracket during export. Require formula to add in

[mc2468]

Hi,

Firstly thanks in advance your help on this.

An issue that we've come across today is that our Accounting package has stopped adding an open "(" for negative values when exporting to Excel. However it is including the closing ")". I'm wondering if anyone can help add an open "(" to all cells that contain a closing ")"

I've attached a simple S/S showing what the export is giving us and what we require.

Many thanks

[Pete_UK]

You can use this formula in C2:

=IF(ISNUMBER(A2*1),A2*1,IF(RIGHT(A2)=")","("&TEXT(SUBSTITUTE(A2,")",""),"0.00")&")",A2))

Format the cell as number with 2 dp, then copy down.

Hope this helps.

Pete

[mc2468]

Hi Pete,

Thanks for your quick reply. It worked perfectly.

Many thanks