| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find/replace "cr" from end of number to "-" in front of number
i have a spreadsheet with lots of numbers downloaded from our AS$)) system.
unfortunately, the columns have valid numbers and numbers like "******.**CR" (* = a valid number). i cannot get excel to convert the "CR" at the end of the number to a minus sign in the front of the number. any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find/replace "cr" from end of number to "-" in front of number
Try:
=LEFT(A1,LEN(A1)-2)*-1 HTH "Dave o" wrote: i have a spreadsheet with lots of numbers downloaded from our AS$)) system. unfortunately, the columns have valid numbers and numbers like "******.**CR" (* = a valid number). i cannot get excel to convert the "CR" at the end of the number to a minus sign in the front of the number. any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find/replace "cr" from end of number to "-" in front of number
this really helped - thanks.
i did need to copy three columns of data and then apply that line to each "CR" value. i then referenced the original columns. MANY THANKS! "Toppers" wrote: Try: =LEFT(A1,LEN(A1)-2)*-1 HTH "Dave o" wrote: i have a spreadsheet with lots of numbers downloaded from our AS$)) system. unfortunately, the columns have valid numbers and numbers like "******.**CR" (* = a valid number). i cannot get excel to convert the "CR" at the end of the number to a minus sign in the front of the number. any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with number formats when using Find/Replace | Excel Discussion (Misc queries) | |||
| Find/Replace last couple of digits on number | Excel Worksheet Functions | |||
| count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
| Adding + in front of a number | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
