How to retain decimal zeroes?

  • Thread starter Thread starter Antony
  • Start date Start date
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.
 
Anthony,

FWIW I think this 'User' needs a reality check. Excel formatting to 3
decimal places is the perfect way to do this and isn't that onerous to do and
certainly not as onerous as other methods for example =TEXT(A1,"0.000")

You could format the columns using VB when the file is opened and don't tell
the user.

Mike
 
How do I do that ? (I have given double quotes around the nemeric value.
Would that make it as a text)
 
Back
Top