| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
zero fill leading digits
Hi,
I need to zero fill field then import result into a program that requires numbers not text or blanks in field. Program will accept ".dbf,.csv or.txt" file formats only. I tried repeat function but when I save in one of the formats excel converts zero to text not number. This then is kicked out by program. thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
zero fill leading digits
I think you need a custom format that keeps leading zeroes. In the format
menu - Numbers - Custom either use one of the custom formats or create your own. In a formula you can do the same thing with the text statement such as =text(mynumber,"0.00") "RLB" wrote: Hi, I need to zero fill field then import result into a program that requires numbers not text or blanks in field. Program will accept ".dbf,.csv or.txt" file formats only. I tried repeat function but when I save in one of the formats excel converts zero to text not number. This then is kicked out by program. thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "0" as leading digits into cells in Excel | Excel Worksheet Functions | |||
| Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
| Validation rule - custom 5 digits w/ leading zeroes | Excel Worksheet Functions | |||
| How do I make a number have leading zeros to fill width of cell? | Excel Discussion (Misc queries) | |||
| Leading digits | Excel Discussion (Misc queries) | |||
Linear Mode
