S*******s
发帖数: 13043 | 1 it is quite often that excel transfer some cusips into scientsific numbers
when copy & paste. it is often too late to realize it and it would waste a
lot time to restore the right cusip. is there anyway to make excel dumber,
disabling its automatic interpretation? |
s******e
发帖数: 1751 | 2 usually ppl add a single quote in front, then strip that off when using the
cusip (in BBG for example).
【在 S*******s 的大作中提到】
: it is quite often that excel transfer some cusips into scientsific numbers
: when copy & paste. it is often too late to realize it and it would waste a
: lot time to restore the right cusip. is there anyway to make excel dumber,
: disabling its automatic interpretation?
|
S*******s
发帖数: 13043 | 3 is there any easy way to add the quote when copying from BBG?
the
【在 s******e 的大作中提到】
: usually ppl add a single quote in front, then strip that off when using the
: cusip (in BBG for example).
|
k*****n
发帖数: 117 | 4 1. format the target cells as 'text'
2. copy source cuips, paste special, values only |
S*******s
发帖数: 13043 | 5 exactly what i'm trying to avoid
【在 k*****n 的大作中提到】
: 1. format the target cells as 'text'
: 2. copy source cuips, paste special, values only
|
l***m
发帖数: 920 | 6 你可以在CUSIP前面加个C。
如果你会用&, LEFT, RIGHT, MID，handle这些很简单。 |
