How to retain decimal zeroes?

[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.

 

[Bob I]

Make it all text.

 

[Mike H]

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

 

[Antony]

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

 

[Antony]

Thanks Mike. I think I may have to force the user to accept the fact.

 

[Bob I]

And import it as TXT file not CSV.

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

: