Discussion Board for collaboration on QlikView Scripting.
Could you give an example of the format of your text file and how the interpreted number looks like?
QV sometimes interpretes strings as date and time automatically, a time value is then stored as fraction of day, e.g 18:00:00 in the evening would translate to number 0.75
If you think that what has happened, you can use a format function to format your number given a format code, like
=Time( 0.75, 'hh:mm:ss')
=Time(0.75, 'hh:mm:ss tt')
Have a look at the HELP, search for 'format codes' and 'date and time functions'.