| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
minus sign
some cells have numbers like 345- instead of -345, can someone suggest a function that changes the minus sign around. PS some cells have more than 3 numbers. Thanks evereyone. -- tom mcdonald ------------------------------------------------------------------------ tom mcdonald's Profile: http://www.excelforum.com/member.php...o&userid=24369 View this thread: http://www.excelforum.com/showthread...hreadid=534053 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
minus sign
=IF(RIGHT(A1,1)="-",-VALUE(LEFT(A1,LEN(A1)-1)),A1)
-- Kind regards, Niek Otten "tom mcdonald" wrote in message ... | | some cells have numbers like 345- instead of -345, can someone suggest | a function that changes the minus sign around. | PS some cells have more than 3 numbers. Thanks evereyone. | | | -- | tom mcdonald | ------------------------------------------------------------------------ | tom mcdonald's Profile: http://www.excelforum.com/member.php...o&userid=24369 | View this thread: http://www.excelforum.com/showthread...hreadid=534053 | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| plus and minus sign in cells | Excel Worksheet Functions | |||
| Formatting: Display a minus sign before a number | Excel Discussion (Misc queries) | |||
| How do I find and replace a number with a minus sign in front? | Excel Discussion (Misc queries) | |||
| I want to display the minus sign | New Users to Excel | |||
| moving minus sign from right to left | Excel Worksheet Functions | |||
Linear Mode
