A
Antony
Hi
A csv file is created by a program and gets opened by Excel. The file
contain interest rates with 3 decimal places. such as 5.340, 3.300 etc. When
the file is opened in Excel, excel automatically strips the trailing zeros.
This becomes 5.34 and 3.3. Though the value is not changed, the user is
adamant to see 3 decimal places after decimal point. User doesnt want to set
the column properties or set it as Number data type. Is there anyway to
retain the trailing zeros without setting any Format in excel?
Thanks.
A csv file is created by a program and gets opened by Excel. The file
contain interest rates with 3 decimal places. such as 5.340, 3.300 etc. When
the file is opened in Excel, excel automatically strips the trailing zeros.
This becomes 5.34 and 3.3. Though the value is not changed, the user is
adamant to see 3 decimal places after decimal point. User doesnt want to set
the column properties or set it as Number data type. Is there anyway to
retain the trailing zeros without setting any Format in excel?
Thanks.