excel macro

[Jem]

hi to all,

I have this data 1234 in cell K27.
how to make macro that will add "0 to the beginning:

My data is:

1234

That the result will look like this:

"01234



Thanks,
Lorena
(e-mail address removed)

 

[Lars-Åke Aspelin]

hi to all,

I have this data 1234 in cell K27.
how to make macro that will add "0 to the beginning:

My data is:

1234

That the result will look like this:

"01234



Thanks,
Lorena
(e-mail address removed)

try this macro:

Sub jem()
With ActiveSheet
.Cells(27, 11) = """0" & .Cells(27, 11)
End With
End Sub

Hope this helps / Lars-Åke

 

[Don Guillett]

Or, you can just custom format as 00000

 

[Lars-Åke Aspelin]

Or, you can just custom format as 00000

That will only give you the 0, not the " I guess.

 

[Don Guillett]

I guess that's right if that's what OP wants???

 

[Tom Ogilvy]

then you could use the custom number format \"00000

But the cell would still just contain 1234 - don't know what the OP wants
actually stored in the cell

for a macro:

Sub FormatCell
ActiveCell.NumberFormat = "\""00000"
End sub