scientific notation hassle

I

irisheyes99

My comapany's tracking software uses a 17 digit id at the end of the ur
string. When I export these url strings to Excel I can see the actual 1
digit id without a problem.
However, on occasion, I need to see *only* the id number, but when
separate the id number from the rest of the string, Excel insists o
putting the number into scientific notation. Is there anyway t
override this feature? I've tried forcing a format into the cells, bu
Excel ends up rounding the number value and thus changes the id
:confused
 
P

Peter Atherton

Hi

Text is still the way. Can you add a space or apostrophe
to the beginning of the ID?e.g. '012345 or " 0123245"

Regards
Peter
 
Top