F FSt1 Jan 20, 2010 #2 hi would be nice if we knew what version excel you are using. 2003 on the menu bar>tools>options>general tab>uncheck R1C1 reference. 2007 Office button>Excel options>formulas>uncheck R1C1 reference regards FSt1
hi would be nice if we knew what version excel you are using. 2003 on the menu bar>tools>options>general tab>uncheck R1C1 reference. 2007 Office button>Excel options>formulas>uncheck R1C1 reference regards FSt1
F Faraz A. Qureshi Jan 20, 2010 #3 Use =Text(A1,"0") to convert the number to text and copy (Ctrl+C) and paste the values (Alt, E, S, V, Enter). "0" in the formula represents a single digit for the same purpose. "000" would convert 1 to 001 (But in text).
Use =Text(A1,"0") to convert the number to text and copy (Ctrl+C) and paste the values (Alt, E, S, V, Enter). "0" in the formula represents a single digit for the same purpose. "000" would convert 1 to 001 (But in text).
