An excalibur report printed into an excel table displays its negative numbers
with the negative sign at the end of the number. How can I move all of the
incorrect negative signs to the front of the number without having to move
them all individually?

See

http://www.mcgimpsey.com/excel/postfixnegatives.html

In article <C3D7E89D-E5B5-41AF-A325-(E-Mail Removed)>,
Leighanne0213 <(E-Mail Removed)> wrote:

> An excalibur report printed into an excel table displays its negative numbers
> with the negative sign at the end of the number. How can I move all of the
> incorrect negative signs to the front of the number without having to move
> them all individually?

> An excalibur report printed into an excel table displays its negative
> numbers with the negative sign at the end of the number. How can I
> move all of the incorrect negative signs to the front of the number
> without having to move them all individually?

Using a worksheet function: put this formula in a temporary "helper column":

=IF(RIGHT(A1,1)="-",LEFT(A1,LEN(A1)-1)*-1,A1)

(adjust cell ref accordingly) and copy down. Then copy / paste values the
cells from the helper column back to the original column.

A similar approach could be done with VBA, without having to use a temporary
helper column.

Data>Text to Columns>Next>Next>Advanced.

Make sure "Trailing minus etc." is checkemarked.


Gord Dibben MS Excel MVP

On Thu, 3 May 2007 14:31:00 -0700, Leighanne0213
<(E-Mail Removed)> wrote:

>An excalibur report printed into an excel table displays its negative numbers
>with the negative sign at the end of the number. How can I move all of the
>incorrect negative signs to the front of the number without having to move
>them all individually?