NEED HELP....easy

**Chapman62083** · 01-30-2009, 08:38 PM

I have a column of data. Half of it is in code format (BEL-A-001) and the other half is just numerical (129). I want the whole column to show in code format. so i just want to attach the 'BEL-A-###' to the given numbers. How do i do this. I have attached the spreadsheet.

**caholmes** · 01-30-2009, 08:53 PM

I would probably use a custom format for this.

Select column A
Format >> Format Cells
Select the Number Tab
Select Custom
Type this in exactly as you see it including the quotes: "BEL-A-"000
Click OK

That should give you what you need

**shg** · 01-30-2009, 09:01 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.