[RESOLVED] [Excel] Weird result in Excel when formatting to time: mm:ss.00

[adrian1906]

I have code that extract results from posted track and field results and produces reports for each athlete on our team. For the time results, I format them so that they all have the format mm:ss.00. This means that results for the 55m dash would look like

00:07.79

and results for a race walk may look like

20:05.00

It looks fine on the worksheet however when I save the reports as PDF files, there is an occasional ? with a box around it. I am formatting using the following command:
Range("A1").NumberFormat = "mm:ss.00"

I have been able to determine a difference between the cells that print properly and the ones that produce the funny character.

Lets say I have two cells, one with 00:07.40 and one with 00:07.79. When I click on the 1st cell, I see the date equivalent in the entry bar (12:00:08 AM) but when I click on the 2nd, I see the same text in the entry bar (00:07.79). I confirmed that both cells are indeed formated using mm:ss.00 by right clicking on the cells and choosing Format Cells. The second cell is printing with the strange character.

Thank you.