# format issue

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

Format the cell as text before you paste.

"Cip" wrote:

> 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

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.


"Cip" wrote:

> 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

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

"Mustafa" wrote:

> 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.
>
>
> "Cip" wrote:
>
> > 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