I have imported an American csv-file into a German Excel XP. The American
$-values are separated by a "." while the German currency values are
separated by a ",".
So now my spreadsheet reads a value of $ 18.01 as 18. January. All values
above 18.12 are ok.
How can I avoid this problem? Or, can I change the values tediously one cell
after the other? I have not found a way yet as even when I try to format a
cell user defined it automatically changes to the format used in the German
region.
Thanks.
Hans

Temporarily change the regional settings on your computer to the same format
(start>control panel) as US,
then when you have opened the csv file, save it as an xls file. Close excel
and change the settings back to German and open the same file.. Voila!

--

Regards,

Peo Sjoblom


"Kraut55" <(E-Mail Removed)> wrote in message
news:bnrg1h$pid$06$(E-Mail Removed)...
> I have imported an American csv-file into a German Excel XP. The American
> $-values are separated by a "." while the German currency values are
> separated by a ",".
> So now my spreadsheet reads a value of $ 18.01 as 18. January. All values
> above 18.12 are ok.
> How can I avoid this problem? Or, can I change the values tediously one
cell
> after the other? I have not found a way yet as even when I try to format a
> cell user defined it automatically changes to the format used in the
German
> region.
> Thanks.
> Hans
>
>

@Peo

Thanks very much. I am going to try that immediately.
Hans

"Peo Sjoblom" <(E-Mail Removed)> schrieb im Newsbeitrag
news:(E-Mail Removed)...
> Temporarily change the regional settings on your computer to the same
format
> (start>control panel) as US,
> then when you have opened the csv file, save it as an xls file. Close
excel
> and change the settings back to German and open the same file.. Voila!
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
> "Kraut55" <(E-Mail Removed)> wrote in message
> news:bnrg1h$pid$06$(E-Mail Removed)...
> > I have imported an American csv-file into a German Excel XP. The
American
> > $-values are separated by a "." while the German currency values are
> > separated by a ",".
> > So now my spreadsheet reads a value of $ 18.01 as 18. January. All
values
> > above 18.12 are ok.
> > How can I avoid this problem? Or, can I change the values tediously one
> cell
> > after the other? I have not found a way yet as even when I try to format
a
> > cell user defined it automatically changes to the format used in the
> German
> > region.
> > Thanks.
> > Hans
> >
> >
>
>