Hey guys,

Wasn't sure if this was a VBA or General question but here it goes.

I'm writing a macro that selects a time on one sheet and needs to identify the row that time appears on another sheet. Before doing this, the macro changes all time values to hh:mm:ss.0 format on both sheets. The problem is that with the second page that is being searched, the time is never found using search. Take a look: http://imgur.com/3c4ZxyK Note the time that appears in the formula bar is not the right format, even after the format has been changed.

And it gets weirder, if I select show formulae, I get this: http://imgur.com/ryydvJm which is the fraction of 24 hours that the time corresponds to. I can't change this, even if I change the format this is the formula. If I select Cell"A3".Value I end up with this number. Note I have searched by values and formulae, I have copied and pasted as value. It's like the format I change it to only exists visually. The interesting thing is that if I select a cell and say cell("A3").text I see my time format, but I can't change the cells to their text property or create a new row of them as their text property.

The weird thing is that this used to work so I fear I may have changed a setting or something. I have run out of people to ask, if anyone knows what's going on here, I'd