Decimalseparator in text import wizard in Excel 2007

L

Lars

I'm having a problem imporing textfiles containing numbers formatted with dot
(.) as decimalseparator (I'm on a Norwegian system, running Vista Business,
and my default setting is comma (,) as separator).

When I change the decimalseparator character in the advanced settings to a
dot, and finish the wizrd, my data is still imported using comma as
separator.

The setting do not updated it self if I change the value, push OK on the
advancedsettings dialog and enter the advanced dialog again.

When I do this on my Excel 2003 version (WinXP), it works perfect.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top