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
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.