| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retain decimal zeroes?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to retain decimal zeroes?
Make it all text.
Antony wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to retain decimal zeroes?
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" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to retain decimal zeroes?
How do I do that ? (I have given double quotes around the nemeric value.
Would that make it as a text) "Bob I" wrote: Make it all text. Antony wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to retain decimal zeroes?
Thanks Mike. I think I may have to force the user to accept the fact.
"Mike H" wrote: 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" wrote: 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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to retain decimal zeroes?
And import it as TXT file not CSV.
Antony wrote: How do I do that ? (I have given double quotes around the nemeric value. Would that make it as a text) "Bob I" wrote: Make it all text. Antony wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I set the default for "show zeroes" to not show the zeroes? | Setting up and Configuration of Excel | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Linear Mode
