I have a CSV file which has time in a format of hh:mm:ss.milli.

I was using Right(CELL, 3) which takes the last 3 digits which is the millisecond. This was working fine until I got some new data sets.

In this new data set, When I take Right(CELL,3), its suddenly giving me the last 3 digits of the excel time format converted (which goes from 0-1 in a day).

Do I have to do some formatting? I don't understand why it wont just give me the last 3 digits of my hh:mm:ss.milli, and is instead converting it to the 0-1 value and giving me the last 3 of those.

Thanks for any help.