| Byg Software |
051 |
| Sometimes downloaded data has trailing negative signs, like this: | How can you convert it to this: |
1 2- 3 4- 5 |
1 -2 3 -4 5 |
| Use this UDF (User Defined Function): | |
'' ***************************************************************************
'' Purpose : Convert numbers with trailing negative sign
'' Written : 20-Aug-2002 by Andy Wiggins, Byg Software Limited
''
Function ConvertTrailingNeg(pVar_NumToConvert)
Application.Volatile
ConvertTrailingNeg = CDbl(pVar_NumToConvert)
End Function
|
|
| If the range containing the data is A1:A5, put "=ConvertTrailingNeg(A1)" in cell B1 then copy it down to cell B5. The numbers are converted! Then copy and paste the values from B1:B5 into A1:A5. | |
| Close | |