Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Formating for Excel Export Post Reply Post New Topic
Author Message
icw001
Newbie
Newbie


Joined: 13 Feb 2012
Online Status: Offline
Posts: 4
Quote icw001 Replybullet Topic: Formating for Excel Export
     Posted: 08 Nov 2012 at 6:33am
I have field in the report which is formated as :
123.456
 
However when I export this report to to Excel it displays
123,456 in Excel. Is there any way to preserve formating in Excel?
I need to display . instead of ,
 
Thanks a lot!!
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 08 Nov 2012 at 7:10am
switch it totext(field)
IP IP Logged
icw001
Newbie
Newbie


Joined: 13 Feb 2012
Online Status: Offline
Posts: 4
Quote icw001 Replybullet Posted: 08 Nov 2012 at 7:40am
Thanks!
It worked
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.