Excel Format Numbers

Question

1.00/5 (1 vote)

See more:

I have an excel which contain numeric and some numbers are displayed with one decimal where there actual value contain 2 decimals for ex it display 0.3 and when I select that cell its value is 0.25

My problem is I'm saving that excel file as xlUnicodeText:

xlSheet.SaveAs(FileName, Excel.XlFileFormat.xlUnicodeText)

and the data in my text file are displaying it as 0.3.

How I can make it to take and save it in my text file as its true value 0.25 and not as it is displayed?

Posted 9-Jul-14 0:42am

TheWebDeveloper

Add a Solution

Comments

[no name] 9-Jul-14 7:57am

Try changing the format in your Excel sheet.

TheWebDeveloper 9-Jul-14 8:05am

The user don't want to do that they want it to be programmed

CHill60 9-Jul-14 8:15am

Then *programmatically* change the format of the sheet before you save it to text.

TheWebDeveloper 10-Jul-14 1:54am

Yes that is my question, how to do that?

Maciej Los 9-Jul-14 9:25am

Are you sure there is a 0.25 instead of 0.3?

2 solutions

Add a Solution

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

CHill60 · Answer 1 · 2014-07-10T00:43:00

Solution 2

To programmatically remove the formatting that is causing the problem try something like this

C#

Excel.Range oRng = MySheet.UsedRange;   // or whatever range you need
oRng.NumberFormat = "General";

This also works

C#

oRng.NumberFormat = null;

Posted 10-Jul-14 0:43am

CHill60

Thakkar Vipul · Answer 2 · 2014-07-09T02:00:00

Solution 1

can you try this ?
http://social.msdn.microsoft.com/Forums/office/en-US/2465ee18-ba4c-49f9-bf30-e151699be103/excel-cell-format-issue?forum=exceldev[^]

Posted 9-Jul-14 2:00am

Thakkar Vipul

Comments

CHill60 9-Jul-14 8:14am

What's that got to with the format being saved to the text file?

Excel Format Numbers

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Excel Format Numbers

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us