Ebays long item numbers in Excel

cafenervosa_2

Since ebay extended the item numbers from the likes of 9150225874 to 300002885187, I have great problems copy and pasting the new longer ones in excel. I even pre format the columns in advance and the numbers still end up with a + 11 on the end.

Any advance of how to set up excel for these new numbers?

Hintza

Great question I'm having the same problem. I correct manually "format cell" but it just adds time and hassle.

Any ideas anyone?

frivolous_fay

Yeah, ditch excel and get a database ;-)

<--- database geek.

Hintza

frivolous_fay wrote:

Yeah, ditch excel and get a database ;-)

<--- database geek.

That then brings me onto my next question...any geeks want to make me a database...for a fee?

Other problem is onbidder doesn't accept the new numbers either!!

frivolous_fay

I work with Filemaker but I'd give it a go ;-)

bingo_bango

Select the column you want to format. When it is highlighted, goto 'Format' from the menu, then 'Cells'.
It should bring up a menu of possible types for the cell. It should already be on 'Number', and show 2 decimal places. Set the decimal places to '0' save, and presto........no more '+11'

HTH

Hintza

bingo_bango wrote:

Select the column you want to format. When it is highlighted, goto 'Format' from the menu, then 'Cells'.
It should bring up a menu of possible types for the cell. It should already be on 'Number', and show 2 decimal places. Set the decimal places to '0' save, and presto........no more '+11'

HTH

That is the logical solution but doesn't work! It will do it for any numbers already there but as soon as you add a new line it reverts to +11!!

bingo_bango

Hintza wrote:

That is the logical solution but doesn't work! It will do it for any numbers already there but as soon as you add a new line it reverts to +11!!

Not on mine. Office XP Pro .... all new lines continue to follow the new rules.

You did click 'save'.....didn't you

Hintza

I presume you mean "OK" there is no save button. Or am I missing something?

bingo_bango

Aye....that'd be the one:o

In work at the moment....so only half paying attention.

Hintza

Just to point out it only happens when you cut and paste the number from EBay and not when you type the number in.

When I buy on EBay I cut and paste the number in.