We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

XLSio Currency Format in cell

Thread ID:

Created:

Updated:

Platform:

Replies:

51948 Nov 17,2006 05:55 AM UTC Nov 17,2006 02:58 PM UTC WinForms 2
loading
Tags: XlsIO
Saurabh Dua
Asked On November 17, 2006 05:55 AM UTC

I am using XLSio but not able to set the format of cell to currency type as to display $4000
It just gives a "file Error: some number formats may have been lost"

Code:

sheet.Range("B3").NumberFormat = "Currency"
sheet.Range("B3").Number = 4000


The code file is also attached herewith as a .zip

code11.zip

Saurabh Dua
Replied On November 17, 2006 06:40 AM UTC

Searched on the forum and found solution:

sheet.Range("B3").Number = 55250
sheet.Range("B3").NumberFormat = "$#,##0_);($#,##0)"

thanks anyways for making this forum

Administrator [Syncfusion]
Replied On November 17, 2006 02:58 PM UTC

Hi Saurabh Dua

Thanks for your interest in XlsIO. Let has know if you have any difficulties in using XlsIO. We promise you a solution with in 24 hours.

With Regards
Chella.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;