#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Minus Sign

Had the formula and lost it. QB sends to Excel with "trailing" - sign.
Need a formula to say - - if right = - put it in front, else just the
number ..
25 Okay
25- make it into -25
will go into next column so can work with it.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Minus Sign

FINALLY found it - But thank you for any and all help in the past. you
people sure make it easier to solve hard probems. Thank You
"JLMcCabes" wrote in message
ng.com...
Had the formula and lost it. QB sends to Excel with "trailing" - sign.
Need a formula to say - - if right = - put it in front, else just the
number ..
25 Okay
25- make it into -25
will go into next column so can work with it.



Reply
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
I do not want the minus sign Steved Excel Worksheet Functions 5 December 8th 08 09:26 PM
minus sign tom mcdonald Excel Worksheet Functions 1 April 19th 06 09:58 AM
plus and minus sign in cells ivoryhunter Excel Worksheet Functions 3 April 10th 06 01:28 PM
I want to display the minus sign ED New Users to Excel 7 October 27th 05 10:06 PM
moving minus sign from right to left GEORGIA Excel Worksheet Functions 3 April 29th 05 02:54 PM


All times are GMT +1. The time now is 05:38 AM.

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

About Us

"It's about Microsoft Excel"