Thanks Tamara insent to you. When I pull up paste special
We gotta go to the crappy town where I'm the hero!
Wash ,'Jaynestown'
Buffistechnology 3: "Press Some Buttons, See What Happens."
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Typo Boy - Mar 05, 2015 8:00:19 pm PST #24383 of 25496
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.
Typo Boy - Mar 05, 2015 8:35:34 pm PST #24384 of 25496
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.
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.
-t - Mar 06, 2015 5:51:41 am PST #24385 of 25496
I am a woman of various inclinations and only some of the time are they to burn everything down in frustration
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.
omnis_audis - Mar 06, 2015 11:16:25 am PST #24386 of 25496
omnis, pursue. That's an order from a shy woman who can use M-16. - Shir
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?
NoiseDesign - Mar 06, 2015 11:18:35 am PST #24387 of 25496
Our wings are not tired
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.
DXMachina - Mar 06, 2015 12:17:25 pm PST #24388 of 25496
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
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.
Typo Boy - Mar 07, 2015 8:24:59 am PST #24389 of 25496
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.
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.
-t - Mar 07, 2015 8:34:59 am PST #24390 of 25496
I am a woman of various inclinations and only some of the time are they to burn everything down in frustration
Glad you figured it out. Sorry I wasn't much help!
Typo Boy - Mar 07, 2015 9:03:49 am PST #24391 of 25496
Calli: My people have a saying. A man who trusts can never be betrayed, only mistaken.Avon: Life expectancy among your people must be extremely short.
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.
DXMachina - Mar 07, 2015 11:37:30 am PST #24392 of 25496
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
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.