Results 1 to 2 of 2
Thread: auto fill / formatting
2001-05-15, 20:58 #1iruserGuest
auto fill / formatting
I am trying to automatically fill a column of a spreadsheet that can be saved as a text file as follows.
If in column A I have In column B I need
In column B I want these numbers as four digit numbers.
I need to save this as a text file so column B cannot be formatted as numbers as the leading 0's will not save.
Will concatenate fill in the required number of 0's? If not is there a function that will?
2001-05-15, 21:27 #2
- Join Date
- Feb 2001
- Dublin, Ireland, Republic of
- Thanked 0 Times in 0 Posts
Re: auto fill / formatting
You could convert the numbers to text with the TEXT() function so that if A1 contains 1, then TEXT(A1,"0000") will return 0001 as text.
Hope that can help you.