In nome of my versions does paste special and the equivalent of text only solve the problem. However, if I go back to the source page and paste as text only in 2007 rather than 2003 from the source page, it pastes directly as numbers. But I still cannot figure out what is in the sheet I sent you. Seems to be neither text nor numbers.

Got it. Huh, that's pretty weird. I have to do my job for a while, but I will poke at it some more when I have a chance.

I'm trying to install bootcamp/Win7-32bit on a work Mac Tower (cheese grater style). It's OS is capped at 10.7.5. It looks like Win7 will work. It wouldn't do the 64-bit version. Here is the problem.

I've got it almost all installed. It looks to need one final reboot, and then does some Windows magic after booting. However, the damn thing won't launch Windows. You get the pretty logo. Then it reboots, with a screen saying might be damaged. Either boot into safe mode, or boot with the installer disc, and click repair. So I try to boot into safe mode, and then it pops up with a "the last bit that needs installing can't install in safe mode, reboot". When I boot from installer disc, and try to repair, it says nothing is wrong.

Anyone have a clue what might be the problem?

I went through a similar issue a few years ago on my older Mac Pro towers and I don't think I ever did figure it out.

Typo, one quick thought on your problem. Have you checked the category (general,text, etc.) of the cells are formated in, both for the pasted cell and for the cell with the value function in it? Perhaps the formatting is such that the data isn't in the form excel is expecting?

If you want to send me your test sheet to look at, my profile addy is good.

I finally figured out using the LEN function. There is a trailing non-printable character that is not visible that carried over from the web page. If I use the following: =VALUE(LEFT(A1,LEN(A1)-1)) I get the cell. Unfortunately, CLEAN does not work for this. Don't know how to generalize beyond this to remove all non-numeric characters regardless of where they are in the string - but I'm sure there are ways to do this using various find functions. At any rate, that works for this data set where I can hard code that I only need to remove on character from the far right.

(According to the Excel CODE function, it is character(160), the non-breaking space, so I could also hard code that with SUBSTITUTE, which would be position independent. Generalizing it to all non-numeric characters would be a bit tougher, but I'm sure there is a way.)

Thanks -t for taking the time, and DX for your offer.

Glad you figured it out. Sorry I wasn't much help!

Well you really were. Your not being able to figure it out told me it was not just a combination of my being rusty in Excel and sleep deprived. Gave me the confidence to assume if I tried something and it failed, it was not just because I was doing it wrong. Then stuff sort of clicked. Just the confirmation that the problem was real and that I was not an idiot for not seeing it instantly was a big help.

Yeah, that makes sense. Glad it's working.

Don't know how to generalize beyond this to remove all non-numeric characters regardless of where they are in the string

While thinking about this, I did a search, and came up with this thread, whic towards the end has some code that might do what you want.

I am going to try seeing if the SSD is readable out of Smonster's water-dead Macbook Air (2010 model).

After that, I may try to replace the Mobo and power board for my own project.

Anyone have any spare parts for Macbook Airs? I'm hoping to find one with a smashed screen, but so far, prices are hella high for spare parts.

I guess I'm hesitant to take the $25-$40 plunge for just the power board just to see if it's the board, Board and Mobo, or just Mobo.