# format issue

C

Cip

Here is my dillema,

I have a web page that list information that I copy and paste into a
spreadsheet, this data is linked to a cell that specifically pulls certain
cells and puts them in a format that needs to be copied to another
application (end up with 4123432154325645,NYCE,500,Data....), my problem is
that when I copy the data over to excel it is formatting my card info into
X^2 format.(ex 4111555566669999 becomes 4.1115E+15 and shows it as
4111555566669990 on my linked cell, need to show all 16 as is) How do I get
excel to not do this or how else can get the same results. Please Help, this
would be a huge time saver for this group that today has to key it in
manually which causing keying issues
 
M

Mustafa

After you paste the number, change the cell Format to "Number". Don't Forget
to decrease the "Decimal Places" to ( 0 ) and make sure the "Use 1000
Seperator (,)" check box is not checked.
 
C

Cip

Thanks everyone , this does not need to be in a number but could be a text
field, this is a card number that needs to keep the properties of a text
fields, any idea to keep excel from converting to sciencetific notation, that
the problem

thanks again
 
Top