FORMATTING CELLS FOR QUICK INPUT
jOY wrote:
I AM WORKING HARD TO FIND A WAY TO MAKE THE FOLLOWING POSSIBLE,
COLUMN A
AZ6-24-00001
AZ6-24-00002
AZ6-24-00003..........
I NEED THIS COLUMN TO BE ABLE TO GO ON FOREVER WITH THE CORRECT FORMULA, I
LOOKED AT OHER POSTS AND AM GETTING CLOSE WITH THE POST OF ="AZ6-24-000"&A49
BUT IT DOESN'T QUITE WORK LIKE I NEED, SOME ONE PLEASE HELP!!
="AZ6-24-"&RIGHT("0000"&ROW(1:1),5)
|