UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Character lenght    
 
   
dyrdasteve
post Jun 23 2004, 06:26 PM
Post #1

UtterAccess Guru
Posts: 910
From: Calhoun, GA
I have a tracking number that is 22 characters in length which is being copied from a warehouse database system and I want to paste it into an excel spreadsheet.

What I get when I paste is this .... 9.61E + 21

How come I cannot just enter in all 22 numeric characters and not have excel re-format it some other way?

Thanks,
Steve
Go to the top of the page
 
+
 
 Start new topic
Replies (1 - 5)
xteam
post Jun 23 2004, 07:31 PM
Post #2

UtterAccess VIP
Posts: 3,667
From: Toronto, ON
change the Cell format to text
Go to the top of the page
 
+
dyrdasteve
post Jun 23 2004, 10:24 PM
Post #3

UtterAccess Guru
Posts: 910
From: Calhoun, GA
Thanks but there is still some problem. The string goes to all zeroes after 15 digits.

Any other ideas?
Go to the top of the page
 
+
xteam
post Jun 23 2004, 11:20 PM
Post #4

UtterAccess VIP
Posts: 3,667
From: Toronto, ON
an idea would be ...before moving data into Excel, create a new field based on your original 22numeric field and add an ' before. So 12345... will be '12345.... This way Excel will see those values as text.
Go to the top of the page
 
+
dyrdasteve
post Jun 24 2004, 02:47 AM
Post #5

UtterAccess Guru
Posts: 910
From: Calhoun, GA
I do appreciate that ... and that does work.

Thanks!
Go to the top of the page
 
+
xteam
post Jun 24 2004, 07:01 AM
Post #6

UtterAccess VIP
Posts: 3,667
From: Toronto, ON
You're very welcome!
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 04:40 AM