dbTalk Databases Forums  

Univers - Export CSV with commas in numbers colums

comp.databases.pick comp.databases.pick


Discuss Univers - Export CSV with commas in numbers colums in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Simon
 
Posts: n/a

Default Univers - Export CSV with commas in numbers colums - 11-11-2003 , 05:01 PM






I know how to export a CSV file of data from Universe, but I would
like to have the colums contiaing numbers, having commas in for these
values when opening the file in Excel.

eg:
Name Qty
Bike 2,000
Pedals 16,000
Handle Bars 427

Reply With Quote
  #2  
Old   
Gulraj Rijhwani
 
Posts: n/a

Default Re: Univers - Export CSV with commas in numbers colums - 11-12-2003 , 12:28 AM






On 11 Nov, in article
<2cc4e4f9.0311111501.4b691e3e (AT) posting (DOT) google.com>
simon.adams (AT) salmat (DOT) com.au "Simon" wrote:

Quote:
I know how to export a CSV file of data from Universe, but I would
like to have the colums contiaing numbers, having commas in for these
values when opening the file in Excel.

eg:
Name Qty
Bike 2,000
Pedals 16,000
Handle Bars 427
That's a formatting issue within Excel.
--
Gulraj Rijhwani \\ Courtfields Limited, Chessington, Surrey, UK
gdr (AT) courtfields (DOT) com \\ Tel: +44 (0)20 8255 4667 Mo: 07976 431936
http://www.courtfld.demon.co.uk \\ Fax: +44 (0)20 8287 8381
----- Specialist in Pick, Unidata, datacomms and general connectivity -----
All material copyright Gulraj Rijhwani and Courtfields. ALL RIGHTS RETAINED.


Reply With Quote
  #3  
Old   
Cristian Clavero
 
Posts: n/a

Default Re: Univers - Export CSV with commas in numbers colums - 11-12-2003 , 04:48 AM



What about this:

"2,000","16,000","427"

It works with Excel 2000


Regards,


Cristian Clavero


simon.adams (AT) salmat (DOT) com.au (Simon) wrote in message news:<2cc4e4f9.0311111501.4b691e3e (AT) posting (DOT) google.com>...
Quote:
I know how to export a CSV file of data from Universe, but I would
like to have the colums contiaing numbers, having commas in for these
values when opening the file in Excel.

eg:
Name Qty
Bike 2,000
Pedals 16,000
Handle Bars 427

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.