Ebays long item numbers in Excel

bingo_bango

Well I didn't try that scenario........but bear with me while I give it a go.

bingo_bango

See what you mean. From what I can see, it's not the way Excel handles the number on pasting, but clipboard itself. It automatically defaults to matching the source format, which is the exponential version of the number.
I'll have to look at finding a way to tell clipboard to match the destination format, rather than the source format.

cafenervosa_2

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

Thats what I do now but its just takes more time up. I liked the old way.

cafenervosa_2

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!!

same with mine too!

tru

OK I've been playing

Format the whole column to 'number' decimal places 0. Then instead of pasting into the cell, select the cell and paste into the formula bar.

Hintza

Well done troo thanks for that!!

cafenervosa_2

troo wrote:

OK I've been playing

Format the whole column to 'number' decimal places 0. Then instead of pasting into the cell, select the cell and paste into the formula bar.

Works a treat, thanks for that! :T