| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
remove cr character from a + number and change number to - 159cr
I need help I want to remove the "cr" character from + number and change the
+ number to negative on a worksheet. Example 215,814.58cr Result= - 215,814.58 Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove cr character from a + number and change number to - 159cr
=IF(RIGHT(A21,2) ="cr",VALUE(LEFT(A21,LEN(A21) - 2)) * -1, A21)
-- Kevin Vaughn "Cr character on numbers" wrote: I need help I want to remove the "cr" character from + number and change the + number to negative on a worksheet. Example 215,814.58cr Result= - 215,814.58 Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove cr character from a + number and change number to - 159
Thank Kevin, It works
"Kevin Vaughn" wrote: =IF(RIGHT(A21,2) ="cr",VALUE(LEFT(A21,LEN(A21) - 2)) * -1, A21) -- Kevin Vaughn "Cr character on numbers" wrote: I need help I want to remove the "cr" character from + number and change the + number to negative on a worksheet. Example 215,814.58cr Result= - 215,814.58 Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove cr character from a + number and change number to - 159
You're welcome.
-- Kevin Vaughn "Cr character on numbers" wrote: Thank Kevin, It works "Kevin Vaughn" wrote: =IF(RIGHT(A21,2) ="cr",VALUE(LEFT(A21,LEN(A21) - 2)) * -1, A21) -- Kevin Vaughn "Cr character on numbers" wrote: I need help I want to remove the "cr" character from + number and change the + number to negative on a worksheet. Example 215,814.58cr Result= - 215,814.58 Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does last number of a 16 character number always change to 0? | Excel Discussion (Misc queries) | |||
| How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
| Change number format from text to number? | New Users to Excel | |||
| Histograms: how change number of bins | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
