Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns in Excel 2007
Hi,
I'm trying to import a .txt file into excel. My regional settings have a comma as decimal separator and dot as thousands separator. When I import the txt file I click on advanced, and choose dot as decimal separator and comma as thousands separator (because the file comes with these settings). After that excel imports the file, but discards the choices I've made. I tried this in excel 2003 and it works fine. Can someone please try this in excel 2007 and tell me if it works. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to columns 2007 | Excel Discussion (Misc queries) | |||
more than 255 columns in excel 2007 | Excel Discussion (Misc queries) | |||
Text to Columns not working correctly with dates in Excel 2007 | Excel Discussion (Misc queries) | |||
Convert Text to Columns with Excel 2007 beta does not work well | Excel Worksheet Functions | |||
Excel 2007 Beta 2 Error -- Text-to-Columns Wizard Data preview wha | Excel Discussion (Misc queries) |