Copying tables to excel

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,636
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
When I copy data to excel the numbers come over as text

for example

This is what happens in excel. the "numbers" are text that is right aligned so they look like numbers when you look at the cell.
Book1
ABCDE
10.810.750.890.750.78
20.770.650.790.740.88
30.880.800.770.880.89
4
5FalseFalseFalseFalseFalse
6FalseFalseFalseFalseFalse
7FalseFalseFalseFalseFalse
Sheet1
Cell Formulas
RangeFormula
A5:E7A5=ISNUMBER(A1)


Is this happing to anyone else? This is on Excel 2016/Win 10.
 
Is this happing to anyone else?
Yes it is, there is a unicode character 8203 as the last character in the cell and it's being looked into.
 
Does it only apply in certain circumstances? just asking as I have just copied the table in post 1 and various other xl2bb tables and they give Isnumber = TRUE.

The first post in the link (which doesn't have xl2bb above the post) is the one which gives me Isnumber = FALSE. I assume it was posted using the Table BB tags, or is it something else as I have seen various posts that look the same?

Just asking so I am aware until it is fixed.
 
As far as I'm aware it only happens when somebody just copies a section of their sheet & pastes it straight into the reply window. So that you end up with something like

2018PJAC001Primary
0​
4​
17​
5​
0​
2018PJAC001
4​
8​
5​
10​
4​
2018PJAC001
8​
12​
12​
20​
8​
2018PJAC001
12​
16​
663​
50​
12​
2018PJAC001
20​
96​
100​
2018PJAC002Primary
11​
4​
20​
50​
11​
2018PJAC002
4​
8​
1​
75​
4​
2018PJAC002
12​
8​
10​
2018PJAC002
12​
16​
12​
15​
12​
2018PJAC002
16​
20​
1​
25​
16​
 
That explains why it appears so often in posts but I didn't realise what was creating it as I hadn't tried that.

I suppose it looks better than it did on the old board and at least you can copy it into Excel which is better than the influx of images I have seen lately.

The cells I can clean easily with
VBA Code:
ActiveSheet.UsedRange.Replace What:=ChrW(8203), Replacement:="", LookAt:=xlPart
until the fix is in place.
 
Just doing a test as get a different result to Fluff in the Test here forum.

1575673233821.png
 

Forum statistics

Threads
1,213,489
Messages
6,113,947
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top