Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 4th 10, 01:48 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 1
Default How do you keep coma delimited format when open csv

We are creating coma delimited files in unix and tag them with the .csv
extension. Each delimited field is in double quotes. Some of the fileds have
leading zeros which gets lost when opening in Excel. Some of the fields have
dollars and cents and when the cents equals zero it drops the deicmal.

Is there a way to set up Excel to keep the format instead of dropping
decimals or leading zeros, etc.?

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
If I change a point for a coma between two numbers format dont cha MAXRAF80 Excel Discussion (Misc queries) 1 May 27th 08 11:17 AM
delimited file format issue evilyn New Users to Excel 2 November 7th 07 03:03 PM
Coma Separator in Numbers Procash Excel Discussion (Misc queries) 1 August 12th 07 10:08 AM
coma not separating data moinik123 Excel Discussion (Misc queries) 3 March 28th 06 06:21 AM
Create a form to open a comma delimited file ~Rick Excel Discussion (Misc queries) 1 September 29th 05 08:25 PM


All times are GMT +1. The time now is 07:35 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017