PC Review


Reply
Thread Tools Rate Thread

Converting an invalid negative number to recognizable format?

 
 
=?Utf-8?B?TGVpZ2hhbm5lMDIxMw==?=
Guest
Posts: n/a
 
      3rd May 2007
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?
 
Reply With Quote
 
 
 
 
JE McGimpsey
Guest
Posts: n/a
 
      3rd May 2007
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?

 
Reply With Quote
 
IanKR
Guest
Posts: n/a
 
      3rd May 2007
> 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.


 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      3rd May 2007
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?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting Negative Number to Postive number =?Utf-8?B?VGVkZA==?= Microsoft Excel Worksheet Functions 7 2nd Sep 2009 04:34 PM
negative number format jpriddy Microsoft Excel New Users 1 6th Mar 2009 04:41 PM
Negative number format jpriddy Microsoft Excel Worksheet Functions 5 6th Mar 2009 03:58 PM
converting positive number to negative yoshimarine Microsoft Access 2 1st Apr 2008 10:34 PM
Converting a negative number to a positive number =?Utf-8?B?QmFyYg==?= Microsoft Excel Misc 3 1st Nov 2007 02:20 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:50 AM.