Can anyone help me please, i'm having difficulty solving this...

I want to create a macro that will allow the user to input text o
their choosing into a cell that already contains numbers,

ie I have a column full of product codes and i want to be able t
select the cells and run a macro which will bring up a box that wil
allow the user to enter the text of their choosing and when they clic
ok will insert their text before the current numbers in each of th
selected cells.

Any help would be much appreciate

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com