PDA

View Full Version : Help Adding a constant text to a numeric cell



Gman61
09-12-2007, 12:13 PM
Excel 2003 and I just completed a 2 day class but I am stumped. I am trying to write code to add a text (SF-300) to a column of 3 digit numbers starting from 100-999. Can someone help me . I know if I get started I can do it to other columns I have.

Thanks

JKwan
09-12-2007, 12:19 PM
= A1 & "SF-300"

Enter the above formula, change A1 to suite. Do a fill down.

unmarkedhelicopter
09-12-2007, 01:03 PM
That could work but you'd lose use of the numbers.
Go to format cells custom and then enter something like #" SF-300"
include the quotes !!!

Gman61
09-12-2007, 01:12 PM
That works thanks. Geez guess I didnt need code eh.

Thanks