How to retain decimal zeroes?

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

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
 
A

Antony

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top