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: 1
Default how can I save an excel file with long number columns in cvs form.

I need to convert a 20 digit number column in an excel spread sheet to a csv
format but it keeps converting to scientific number. I have save column as
Text, Number and general but no matter what format the long numbers still
revert to scientific. the phone column which is 10 digits converts just fine.
I am using excel 2003 sp3
thanks,
Jim
 
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
Taking long time to save file to sub folder Bill A Excel Discussion (Misc queries) 3 July 19th 07 08:30 PM
Save Excel file with certain columns with fixed width Vijay Kotian Excel Discussion (Misc queries) 3 March 13th 07 01:48 PM
I can't save long file names, only short one, how can I do this? short file names Excel Discussion (Misc queries) 0 January 3rd 06 05:13 PM
Long Save Times with File-Save BrianDavid Excel Discussion (Misc queries) 3 December 20th 05 03:57 PM
Excel file takes a long time to save ben@bikecenturies Excel Discussion (Misc queries) 1 February 3rd 05 12:27 AM


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