Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
minus
when I import a report from business objects I get fields
with the minus sign at the end , e.g stock qty is 400- instead of -400. CAn anyone give me a hand in changing the minus character from the frot to ths last character of the field. Thanks in anticipation. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
minus
Hi Tom!
One formula approach is to use: =IF(RIGHT(D12,1)="-",-1*LEFT(D12,LEN(D12)-1)+0,D12) For a programming approach to the problem: David McRitchie: http://www.mvps.org/dmcritchie/excel...#fixrightminus -- Regards Norman Harker MVP (Excel) Sydney, Australia "tom mcd" wrote in message ... when I import a report from business objects I get fields with the minus sign at the end , e.g stock qty is 400- instead of -400. CAn anyone give me a hand in changing the minus character from the frot to ths last character of the field. Thanks in anticipation. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
minus
In the Data, Text to Column Wizard on the third screen there is an
Advanced... Button where there is the option to convert "Trailing Minus ("-") signs... HTH "Norman Harker" wrote in message ... Hi Tom! One formula approach is to use: =IF(RIGHT(D12,1)="-",-1*LEFT(D12,LEN(D12)-1)+0,D12) For a programming approach to the problem: David McRitchie: http://www.mvps.org/dmcritchie/excel...#fixrightminus -- Regards Norman Harker MVP (Excel) Sydney, Australia "tom mcd" wrote in message ... when I import a report from business objects I get fields with the minus sign at the end , e.g stock qty is 400- instead of -400. CAn anyone give me a hand in changing the minus character from the frot to ths last character of the field. Thanks in anticipation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change all cells from minus to plus and plus to minus | Excel Worksheet Functions | |||
How to set minus value to 0 | Excel Worksheet Functions | |||
plus and minus | Excel Worksheet Functions | |||
Plus or Minus | Excel Worksheet Functions | |||
CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS | Excel Discussion (Misc queries) |