I'm trying to format a column as 6-digit time cells with the format hhmmss so
I can create a time column with the time increasing at regular increments
(for instance, every second or every 15 seconds). The range of values can be
from 000000 (midnight) to 235959 (one second before midnight). Every custom
format I try to create, all of which are variations of hhmmss, insists on
giving me the date with the time, but I've got the date in another column,
and that's where it needs to be.

For example, if I enter 000000, the cell shows 000000, and the formula bar
says 12:00:00 AM. If I enter 000001, the cell shows 000000, and the formula
bar says 1/1/1900 12:00:00 AM. If I enter 000002, the cell shows 000000 and
the formula bar says 1/2/1900, 12:00:00 AM. The date is not only totally
foreign to the hhmmss format, it's worse than useless for what I'm doing.
I'm completely at a loss as to why I only show 000000 no matter what I enter.

My ultimate goal is to concatenate these cells I'm populating with others to
create a long record from each row, so I can't have extraneous colons among
my data. If I use a number format, I can't increment as time -- i.e., after
the 59th second I have one minute instead of 60 seconds. I'm creating these
on the order of ten thousand at a time, so the thought of having to do this
manually is really unattractive.

All help would be greatly appreciated!
Donna