Copying tables to excel

[Scott T]

When I copy data to excel the numbers come over as text

for example

Checking Values in A range lie between 2 values .

Hello, I am working on a worksheet at the moment and have run across a small problem. I have a table/Range with 12 values in it and i am looking to return a True/false, Pass /Fail, based upon the verification that the values lie between the values stored in 2 cells. The 2 Cells are calculated...

www.mrexcel.com

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
	A	B	C	D	E
1	0.81	0.75	0.89	0.75	0.78
2	0.77	0.65	0.79	0.74	0.88
3	0.88	0.80	0.77	0.88	0.89
4
5	False	False	False	False	False
6	False	False	False	False	False
7	False	False	False	False	False
Sheet1

Cell Formulas
Range	Formula
A5:E7	A5	=ISNUMBER(A1)

Is this happing to anyone else? This is on Excel 2016/Win 10.

 

[Fluff]

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.

 

[MARK858]

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.

 

[Fluff]

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

2018PJAC001	Primary	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​
2018PJAC002	Primary	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​

 

[MARK858]

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

ActiveSheet.UsedRange.Replace What:=ChrW(8203), Replacement:="", LookAt:=xlPart

until the fix is in place.

 

[MARK858]

Just doing a test as get a different result to Fluff in the Test here forum.