I need the leading zero to be actually in the cell so formatting the cell
using custom or special will not work as these seem to be for display only.
The cell cannot be formatted for text or you cannot put an apostrophe before
the number as the spreadsheet is read into a database table. The table field
is set up to take characters but does not accept anything with the green mark
in the top left of the cell.