Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS
if i copy and paste data from an AS400 program (KBM or JD Edwards) how to i
change 2000- to be -2000 or (2000) in excel get rid of trailing minues and change them to brackets or to show negative before the number? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS
In a helper column, put this and copy down........
=IF(RIGHT(A1,1)="-",SUBSTITUTE(A1,"-","")*-1,A1) Vaya con Dios, Chuck, CABGx3 "Socal Analyst looking for help" wrote: if i copy and paste data from an AS400 program (KBM or JD Edwards) how to i change 2000- to be -2000 or (2000) in excel get rid of trailing minues and change them to brackets or to show negative before the number? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS
If you have excel 2002 onward you can just select the range, do datatext to
columns and click finish -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Socal Analyst looking for help" . com wrote in message ... if i copy and paste data from an AS400 program (KBM or JD Edwards) how to i change 2000- to be -2000 or (2000) in excel get rid of trailing minues and change them to brackets or to show negative before the number? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
brainteaser: change a value by 90 (but answer must lie between 0-180 ) | Excel Discussion (Misc queries) | |||
change the colour of text in cell for minus figure | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Find function | Excel Worksheet Functions | |||
Find function | Excel Worksheet Functions |