format

use custom format
enter
00000

Lance

"Bill R" wrote:

How do I add leading zeroes to data within an excel column. I'm trying to
convert data into total of 5 numerics by adding leading zeroes into the
string.