Ebay item # format

K

kbooz

I know this question has probably been asked, but I need a step by step
Since Ebay has enlarged their item #'s, I can't get them to paste as
regular whole #. The paste always comes to something lik
this:2.5001E+11. Now, I can go in and format the cell and change it t
number or special or custom and it does change that cell to the righ
visual or I can do the same format to the entire column, but the nex
time i copy and paste it reverts back to the old format (I have save
the new format, but that didn't do it either). I hope I explained i
ok. Just want to format the entire column to stick permanently
 
J

joeu2004

kbooz said:
I know this question has probably been asked, but I need a step by step.
Since Ebay has enlarged their item #'s, I can't get them to paste as a
regular whole #. The paste always comes to something like
this:2.5001E+11.
Click to expand...

Enter the number preceded by an apostrophe ('). Or if you have sufficient
foresight, format the cell as Text (Format > Cells > Number) __before__ you
enter the item number.
Now, I can go in and format the cell and change it to
number or special or custom and it does change that cell to the right
visual
Click to expand...

Well, you got lucky. If the item number were too long (more than 15
digits), it would not have worked because Excel would have changed the number
already. I believe you need to set the format to Text __before__ you enter
the item number.
 
K

kbooz

Changing the column to test revert all my #'s to the wrong format (th
one I am trying to get rid of). I need something that will pre set th
column for future pastings. Right now, all I can do is change eithe
one at a time or I can change the whole column until the next time
paste and that new number goes is as 2.5001E+11
 
Top