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.
Unfortunately, activation email could not send to your email. Please try again.

XLSio Currency Format in cell

Thread ID:

Created:

Updated:

Platform:

Replies:

51948 Nov 17,2006 12:55 AM Nov 17,2006 09:58 AM Windows Forms 2
loading
Tags: XlsIO
Saurabh Dua
Asked On November 17, 2006 12:55 AM

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 01:40 AM

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 09:58 AM

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.

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.

;