Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import decimal numbers with trailing zeros into Excel
I need to import decimal numbers from text files into Excel without losing
format (e.g. trailing zerors are preserved "2.00"). I know that you can import the decimal numbers into Excel as text then the trailing zeros will be preserved. However, I want Excel to treat the values as numbers, preserving the decimals and trailing zeros. Is this possible? Thanks, Jack |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import decimal numbers with trailing zeros into Excel
Excel doesn't store the trailing zeros even if you hand enter them into cells
as numbers. You can show as many trailing zeros as you want if you format the cell to display them - so the solution is to format the cell to show the number of trailing zeros you want. do it manually or with code. -- Regards, Tom Ogilvy "JackCali" wrote: I need to import decimal numbers from text files into Excel without losing format (e.g. trailing zerors are preserved "2.00"). I know that you can import the decimal numbers into Excel as text then the trailing zeros will be preserved. However, I want Excel to treat the values as numbers, preserving the decimals and trailing zeros. Is this possible? Thanks, Jack |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I force trailing zeros in an Excel cell? | New Users to Excel | |||
Trailing zeros | Excel Worksheet Functions | |||
Trailing Zeros | Excel Discussion (Misc queries) | |||
Leading decimal and zeros in formating numbers | Excel Discussion (Misc queries) | |||
Keep numbers as entered with trailing zeros | Excel Discussion (Misc queries) |