Last digits are changed to zeros while writing data table to excel or csv

Help Activities
, ,
1

The Last digit values doesn’t change if written to text file but are changed to zeros while writing data table to excel or csv.

2

@sharad.bodke,

In Excel it will round up the value but in CSV it will not until you open it through excel and save it.

Save it as csv and open it through notepad you will see the numbers as it is.

Thanks,
Ashok :slight_smile:

3

This file is to be used further by the users. They need in excel format.

4

@sharad.bodke

Users will have to do setting in their excel. CSV don’t contains any formats you can control.

https://www.indeed.com/career-advice/career-development/how-to-stop-excel-from-rounding

Thanks,
Ashok :slight_smile:

5

Solved using this Solution. Thanks AKSHAY YADAV

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.