LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
klafert
 
Posts: n/a
Default Showing Negative as Postive

I know I done this before but I am drawing a blank. I am exporting a report
from Crystal Report. I the column contains negative figures. In Crystal I
can tell it to "reverse the sign to display". In other words I can have a
negative show as a postive. However, when I export into Excel it imports as
a negative. I know there is a way to change a negative number to a positive
number in
Excel. Need help ASAP!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting Negative Number to Postive number Tedd Excel Worksheet Functions 7 September 2nd 09 04:34 PM
Automate bar chart color based on value postive or negative kathy Excel Discussion (Misc queries) 1 August 31st 05 09:35 PM
Negative Values Only [email protected] Excel Discussion (Misc queries) 1 August 8th 05 08:58 PM
showing negative numbers dzeitler Excel Discussion (Misc queries) 2 June 8th 05 05:30 PM
reversing signs - making postive a negative number mklafert Excel Worksheet Functions 4 November 29th 04 03:18 AM


All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"