| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add decimal to beginning of number
i am importing fixed width text file but cannot get leading zeros to come
over and can't add decimal to left side of number when in excel. i.e. text file data = 0004 or = 0125 in excel i need to convert to 00.04 01.25 any ideas? thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
add decimal to beginning of number
Put 100 in an empty cell
edit|copy Select the range to fix edit|pastespecial|check divide. Clean up the cell with 100 in it. You'll want to give that range a nice custom format if you really want the leading 0's. ssetech wrote: i am importing fixed width text file but cannot get leading zeros to come over and can't add decimal to left side of number when in excel. i.e. text file data = 0004 or = 0125 in excel i need to convert to 00.04 01.25 any ideas? thank you. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep the 0 at the beginning of a number, ex. 090? | New Users to Excel | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| Is there away to add a zero to the beginning of number string? | Excel Worksheet Functions | |||
| Zero at the beginning of a number | Excel Discussion (Misc queries) | |||
| How to display the number zero at the beginning of a number when . | New Users to Excel | |||
Linear Mode
