LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 119
Default importing numbers as text

I am trying to write a file from another system that will be opened with Excel

If the fields have quotes around them and are TAB separated then it is
pretty easy to get Excel to read it. Some of the fields have values that
look like numbers but really should be treated as text (They are Hex with
leading zeros)

I know that you can use the wizard when you open the file and select the
column and say it is type text. But the people opening the files will fail
to follow dirrections 9 of 10 times if they bother to read them at all.

I thought putting a leading single quote in the field whould make it open as
text but it displays the quote.

Is there anything that can be put in the file to maintain the format while
not displaying in Excel?

TIA
Peter Richardson
 
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
Hex numbers displayed in scientific notation when importing text f Gabriel Nehmer Excel Discussion (Misc queries) 2 July 20th 07 04:08 PM
Importing long numbers from CSV file Harry Excel Discussion (Misc queries) 4 January 14th 07 02:02 AM
Importing CSV file (saved as Text) into XL as Text -- over 60 colu sbp Excel Discussion (Misc queries) 1 October 14th 06 11:50 PM
Retain Numbers as Text Format When Importing. xardoz Excel Discussion (Misc queries) 2 June 20th 06 05:16 PM
Importing text files to Excel with big numbers Orjan Excel Worksheet Functions 0 March 17th 05 07:13 PM


All times are GMT +1. The time now is 04:13 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"