scientific notation hassle

  • Thread starter Thread starter irisheyes99
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

large numbers as text replaced with scientific notation 2
Prevent Scientific Notation 3
text converted to scientific notations 3
Excel turning percentages into scientific notation 2
Scientific notation from a csv file 1
Excel converts 9-digit string to sci. not. when saved as csv 1
Excel reading pasted values as Scientific Notation 3
Import large number string 1

Back
Top