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.

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.