Trouble with auto formating calc
I'm trying to create a formating calculation that will allow me to format time code.
The editors would enter "010005"
It would format to add in the :
So it would become "01:00:05"
I modified the code for formatting phone numbers to:
Case(Length(Source_TC_in) = 6; Left(Source_TC_in;2) & ":" & Middle(Source_TC_in;2;2) & ":" & Right(Source_TC_in;2); "error")
My problem with the calc is that when I enter (for example) 010508
it changes the middle two number to something like 01:01:08.
I'm on FM9 on a Mac.