Excel Macro

[jmuscat]

I am wanting to create a macro that will add a zero to the front of certain cell numbers.
I cannot seem to work it out.
Say column A has 856, I need a macro to change it to 0856, but also use the macro on other values in other cells.
Any ideas

 

[basepointdesignz]

Hi,

What do the other cells contain? Do the cells you want to change have anything in common? Are they in the same row or column, all three digits long, or any other formulaic properties that are identical throughout?

I need to know the pattern of the cells so a criteria-specific search can made of the cells that contain the numbers you want. Let me know and I'll come up with something for you..

Cheers,

Renegade..


BULLET-PROOF DESiGNZ
renegade@tiscali.co.uk

 

[jmuscat]

Basically the cells contain random numbers anything from 856 to 1245634.
In some instances, not all, I need to add an extra zero at the front of the number. The only common factor would be that all the numbers reside in column A.
Many thanks

 

[GlennUK]

Hi jmuscat,

are these cells in column A numeric, or text? If they are numeric, will changing the number format to "0000" be sufficient for you?


Glenn.

 

[Fae]

Easy - add a ' (apostrophe) before you type a cell number or an area code - the ' (apostrophe) identifies the cell then as text.
alternatively
Select all the cells where you will be inserting figures with zeros infront,
point to the selected area,
right click,
select Format Cells,
Click the NUMBER tab
Select Text
Click ok

Alma

Miracles we do immediately ...
imposibilities take a little longer.