| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with open text file in excel 2007
Hi
I have a textfile from a databasa that I every week opens in excel. I haven't had any problems with this until we changed to office 2007. In the textfile there is numbers like 1.072,00- and when I open it in Excel 2003 I get it like -1 072,00 which is exactley what I want. When I do the same settings in 2007 it seems to ignore them and also sets it as text format so it looks like 1.072,00- I have tested it in swedish and english version and I get the same result. My settings: Delimiter : tab Format: general decimalseparotor (under advanced) : , 1000-delimiter: . and I check the little checkbox Thees settings works perfectley for me in 2003 but not in 2007, is it me or is it a bug? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I access favorites in the Excel 2007 Open file command | Setting up and Configuration of Excel | |||
| An Excel 2007 file I had previously used, will not open | Excel Discussion (Misc queries) | |||
| line chart problem when I open file in 2007 | Charts and Charting in Excel | |||
| excel 2007 does not open file on first try | Excel Discussion (Misc queries) | |||
| Can't open Excel 2007 file with 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
