| 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. |
| 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) | |||
Threaded Mode
