Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mau Mau is offline
external usenet poster
 
Posts: 4
Default how to disable automatic nr conversion

Hi David, the output isn't a file, just a screen output of a SAP (the
"famous" ERP) execute command, then you have the "Save as Excel" menu button,
but the problem is that it works very well with Excel97 and very bad with
Excel 2003/2007, and I'm disconcert by this behaviour: I don't want to
reinstall Excel 97 to everybody and I'd like to avoid the futher step of
saving as CSV file and reopen into Excel2007!!!!

Thank you

"David Biddulph" wrote:

You haven't said in what form your report has produced the data. If it is a
CSV, you can either rename the CSV as .TXT, or use Data/ Import External
Data, rather than just opening the CSV. That way, you'll be able to specify
the format of the columns on the import. Specify as text, rather than
General.
--
David Biddulph


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable automatic GETPIVOT news.microsoft.com Setting up and Configuration of Excel 3 July 10th 06 09:19 PM
Disable automatic GETPIVOT news.microsoft.com Excel Worksheet Functions 3 July 10th 06 09:19 PM
Automatic CSV Data Conversion Guillaume Genest Setting up and Configuration of Excel 1 January 6th 06 10:19 PM
Disable Scientific Notation conversion Clark G. Excel Worksheet Functions 2 April 18th 05 05:35 PM
Disable automatic date conversion feature iceseal Excel Worksheet Functions 2 November 12th 04 03:04 AM


All times are GMT +1. The time now is 01:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"