G
Guest
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
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