Hi Alex,

How about selecting the range and setting a custom format of 00000?

Regards,

Peter Beach

"Alex" <. wrote in message
...
Hello,

Is it possible to left pad a cell, but only if it's not blank ?

eg,
600 = 00600
50000 = 50000
[blank] = [blank]

(I've just succeeded for non-blank cells)

Thanks in advance.