跳至內容
選單
此問題已被標幟
590 瀏覽次數

while exporting if i selected the integer values only to export in excel at that time im getting the integer value without fractional point like 34, 33, 77 etc.
but when i added any other float field aslo for export at that time all the integer field which are printed above also coming as float value in the excel like 34.00, 33.00, 77.00, 1000.00

i want like when i select the integer and float field integer field should come as integer floating point value should come as float .

can anyone have the solution for my above problem?


頭像
捨棄

Excel often shows different values in cells than are stored. You can click in the cell and look in the formula line to see the stored value.

Exporting to CSV will always show you the stored value.

相關帖文 回覆 瀏覽次數 活動
4
9月 18
4548
0
8月 15
3822
2
5月 24
2582
2
9月 23
5519
1
1月 25
4711