Want the Values in Decimal of three Digit

Stivan_dsouza21Stivan_dsouza21 Member Posts: 218
Want the Values in Decimal of three Digit but should not get rounded.

Below is the Code which i have written but the value is getting rounded off.
XLSHEET.Range('K'+FORMAT(i)).Value := SpecificGravity;
XLSHEET.Range('K'+FORMAT(i)).RowHeight := 18;
XLSHEET.Range('K'+FORMAT(i)).Font.Size := 10;
XLSHEET.Range('K'+FORMAT(i)).NumberFormat := '#,###0.000';
XLSHEET.Range('K'+FORMAT(i)).EntireColumn.AutoFit;
XLSHEET.Range('K'+FORMAT(i)).HorizontalAlignment :=-4152;


Can Somebody help me out its should not get rounded of.
Thanks & Regards,
Stivan D'souza

Comments

  • GilGil Member Posts: 49
    you can format it and add a quotation to convert it to text when inserting to excel. SO that it would remain as is
Sign In or Register to comment.