Excel Number Format

Question

0.00/5 (No votes)

See more:

Hi,

I am trying to enter numbers in excel cells programatically. I have number formatting code in side my c# program. As a result numbers have differnt decimal places. e.g 12.1200, 2.000, 100.0 etc.

When I print these values in excel, it changes the number of decimal places. How do I ensure that my numbers have same decimal places as I print then. I do not want to change the cells from number to text.

Posted 27-Jul-10 22:36pm

KaurGurpreet

Updated 27-Jul-10 22:39pm

Sandeep Mewara

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2010-07-27T23:07:00

Solution 1

I think you need to set the number format for each cell. Microsoft has a piece of sample code here[^].

Posted 27-Jul-10 23:07pm

Richard MacCutchan

Excel Number Format

1 solution

Solution 1

Add your solution here

Preview 0

Excel Number Format

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us