I have a excel spreadsheet with a macro program. which is shared between two
machine. In one machine a cell with numeric zero when formatted to time shows
value as 12:00:00 and in the other machine it shows 00:00:00.

The macro which is looking for 12:00:00 therefore does not work as the value
is 00:00:00. Both machine are running the same version of EXCEL 2003

I cannot get the cell to read a numeric zero when formatted to time to
display 12:00:00 AM in the second machine.

Please advise and thanks in advance