Hi,
I've an Excel listbox populated with numbers as text i.e.
'001
'002
etc

when selected the item, it returns into a cell in the following format:
1
2
etc.

I need to keep the leading zeros: how can I do it with VBA?

Thanks for any suggestion.

V