One of the fields my original .csv file is a time field having values listed like 58:46.9 in the cell using formatting mm:ss.0, but displayed as 9:58:47 AM in the formula bar. My first question is why are these so different? Is the actual value what is in the formula bar and the cell value is just the displayed value? Secondly, and more importantly, I'm trying to figure out what formatting I need to do in order to make this same field display the value as 9:58:46.9200000 in the cell and formula bar when converting it to text.