LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default Number format in CSV file

Guys,

I'm creating a CSV file containing 13-digit barcode numbers. However, when opened in Excel they display in scientific notation.

Any way I can cause Excel to load the numbers as text, or not use scientific notation, through the CSV file?

Thanks,
Simon.

 
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
Number in text format in CSV file mewild58 Excel Discussion (Misc queries) 4 June 3rd 09 02:21 PM
Number Format on Excel File saved from .html file joyfulone Excel Discussion (Misc queries) 3 April 15th 09 12:07 AM
Time/ Number format on excel file exported from Access Joe[_3_] Excel Discussion (Misc queries) 1 April 18th 07 02:12 AM
Loosing value of large number when saving file to CSV format Kim Luu Excel Discussion (Misc queries) 2 May 1st 06 02:40 PM
How to format a number cell to auto count 1 up on file open Joevee Excel Worksheet Functions 0 February 1st 06 05:00 PM


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