Serious trouble

[fred_m]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Does anything work as it should in Excel 2008 for mac? It feels like Windows Vista. A software never should have been released.

When I download spread sheets from finance.yahoo, and import to excel, crazy things happens.

It adds ".00" to some values (not all values, randomized) and intepret it as date instead of just numbers. When trying "format celles inte values" or/and "seek and replace" to change dots into commas it also do crazy things... I have tried many solutions and nothing works.

I have also tried copy a column and "paste special", choosing "values", into a new spread sheet but that does not work either.

Anyone with same problem who know a solution or is downgrading the only option?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Does anything work as it should in Excel 2008 for mac? It feels like Windows
Vista. A software never should have been released.

When I download spread sheets from finance.yahoo, and import to excel, crazy
things happens.

It adds ".00" to some values (not all values, randomized) and intepret it as
date instead of just numbers. When trying "format celles inte values" or/and
"seek and replace" to change dots into commas it also do crazy things... I
have tried many solutions and nothing works.

I have also tried copy a column and "paste special", choosing "values", into a
new spread sheet but that does not work either.

Anyone with same problem who know a solution or is downgrading the only
option?

None of these problems should be happening. Excel gets its international
settings from the system preferences. Trying to replace commas with periods
(or vice versa) will not fix the problem. Likewise with dates. If you can
provide a more complete explanation we can help with each issue.

For example, what about pasting values does not work? What are the values?
What are the results? What do you think should happen.

You also need to specify what language version of Office you are using, What
update level? What language and update level of the OS?

 

[fred_m]

None of these problems should be happening. Excel gets its international
settings from the system preferences. Trying to replace commas with periods
(or vice versa) will not fix the problem. Likewise with dates. If you can
provide a more complete explanation we can help with each issue.

For example, what about pasting values does not work? What are the values?
What are the results? What do you think should happen.

I did'nt really expect it to help but I made a try anyway
However, when using the paste special function it did not help. The numbers are still strange.

Maybe you have the same problem?
If you want, try download this spread sheet.
It is the closing prices, opening prices and so on over OMX30 (swedish stock exchange). Look at the column "adj. close". Of some reason my excel adds ".00" to some numbers but not all of them.

<http://finance.yahoo.com/q/hp?s=^OMX>

The reason why I want to change from dots to commas is because I can not run formulas in excel using dots. It says "#värdefel" which means "wrong value" or maybe "mispecified value". Not sure about the correct translation.

You also need to specify what language version of Office you are using, What
update level? What language and update level of the OS?

I have Leopard 10.5.6, and have an Intel processor.

I'm from Sweden, and bought it here in Sweden so the language is Swedish. Or do you mean something else?

The update level of excel is 12.1.5
It must be the latest update since office can not for the moment find any more updates.

 

[Bob Greenblatt]

None of these problems should be happening. Excel gets its international
settings from the system preferences. Trying to replace commas with periods
(or vice versa) will not fix the problem. Likewise with dates. If you can
provide a more complete explanation we can help with each issue.

For example, what about pasting values does not work? What are the values?
What are the results? What do you think should happen.

I did'nt really expect it to help but I made a try anyway
However, when using the paste special function it did not help. The numbers
are still strange.

Maybe you have the same problem?
If you want, try download this spread sheet.
It is the closing prices, opening prices and so on over OMX30 (swedish stock
exchange). Look at the column "adj. close". Of some reason my excel adds ".00"
to some numbers but not all of them.

<http://finance.yahoo.com/q/hp?s=^OMX>

The reason why I want to change from dots to commas is because I can not run
formulas in excel using dots. It says "#värdefel" which means "wrong value" or
maybe "mispecified value". Not sure about the correct translation.

You also need to specify what language version of Office you are using, What
update level? What language and update level of the OS?

I have Leopard 10.5.6, and have an Intel processor.

I'm from Sweden, and bought it here in Sweden so the language is Swedish. Or
do you mean something else?

The update level of excel is 12.1.5
It must be the latest update since office can not for the moment find any more
updates.

Well, I copied the data from the web page and pasted it into Excel and it
looks fine. I then pressed the download to spreadsheet button and got a
comma delimited file. I opened that with Excel and that also looked fine.

 

[fred_m]

None of these problems should be happening. Excel gets its international
settings from the system preferences. Trying to replace commas with periods
(or vice versa) will not fix the problem. Likewise with dates. If you can
provide a more complete explanation we can help with each issue.

For example, what about pasting values does not work? What are the values?
What are the results? What do you think should happen.

I did'nt really expect it to help but I made a try anyway
However, when using the paste special function it did not help. The numbers
are still strange.

Maybe you have the same problem?
If you want, try download this spread sheet.
It is the closing prices, opening prices and so on over OMX30 (swedish stock
exchange). Look at the column "adj. close". Of some reason my excel adds ".00"
to some numbers but not all of them.



The reason why I want to change from dots to commas is because I can not run
formulas in excel using dots. It says "#v�rdefel" which means "wrong value" or
maybe "mispecified value". Not sure about the correct translation.

You also need to specify what language version of Office you are using, What
update level? What language and update level of the OS?

I have Leopard 10.5.6, and have an Intel processor.

I'm from Sweden, and bought it here in Sweden so the language is Swedish. Or
do you mean something else?

The update level of excel is 12.1.5
It must be the latest update since office can not for the moment find any more
updates.

Well, I copied the data from the web page and pasted it into Excel and it
looks fine. I then pressed the download to spreadsheet button and got a
comma delimited file. I opened that with Excel and that also looked fine.
[/QUOTE]
Okay so it can not have anything to do with my processor, version of office and so on, since you asked about it? Because it does not work for me, and I discussing this problem at another forum (for Scandinavians) and there is more people sharing this problem.

 

[Laroche J]

I think Bob cannot see the problem because his OS X and Excel number formats
are exactly the same as provided in the Yahoo table.

Try this, if you haven't already done (exactly) so.
Download the table from the Yahoo site. For me it opens a Safari tab with
all data in an unformatted table.
Select all with command-A, copy with command-C.
Go to a blank Excel sheet, select cell A1.
Paste. Everything will appear in column A.
Go to Data, Text to Columns...
Step 1: select delimited data
Step 2: select comma as delimiter
Step 3: for column 1, select format Date as YMD. For columns 2 to 7, select
format General and click on Advanced... Select the period as decimal
separator. Select the destination for the converted data and finish.

Apply format Number with two decimals to columns 2, 3, 4, 5 and 7.

If this still doesn't work, tell us what are your date and number formats in
OS X International preferences.

JL
Mac OS X 10.4.11, Office v.X 10.1.9

 

[fred_m]

Laroche J.

Thank you for taking your time helping me!

However I got help recently in a Scandinavian forum. The problem according to that guy was "the Swedish Excel". I had to use the text editor and do the "seek and replace" procedure in that program instead. So everything is fine now.