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

--
Regards,
Tom Ogilvy


"Don Guillett" wrote:


I guess that's right if that's what OP wants???
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lars-Åke Aspelin" wrote in message
...
On Sat, 12 Jul 2008 06:30:27 -0500, "Don Guillett"
wrote:

Or, you can just custom format as 00000


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