zero fill leading digits

R

RLB

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.
 
J

Joel

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Need 7 digit number with differnt number of leading zeros 10
Lead Zeros in Text 6
Leading Zero Dropped in Text Cell 3
How do I stop Excel from dropping leading zeros? 2
Another Leading Zero Question 7
Time format hh:nn drops leading zero 0
Excel And Notepad 3

Top