numbers are changes when input
 

I am trying to log running/swimming times. I tried to filter the columns, but
it either keeeps rounding the numbers or changing it to a time.
thanks for help!!
--
dna

numbers are changes when input
 

Thanks for the thanks, but do you have a question? Tell us the output you are
looking for, and the input you have, and you will surely get an answer to your
question.

--
Regards,
Fred


"dna" wrote in message
...
I am trying to log running/swimming times. I tried to filter the columns, but
it either keeeps rounding the numbers or changing it to a time.
thanks for help!!
--
dna

numbers are changes when input
 

Hi Fred,

How can I get the times (swimming/running) in the appropriate columns
without them changing themselves? For example the swim record 05:54.96
either rounds or changes to a time. I have tried to clear/ change with
filters.
Thanks!
--
dna


"Fred Smith" wrote:

Thanks for the thanks, but do you have a question? Tell us the output you are
looking for, and the input you have, and you will surely get an answer to your
question.

--
Regards,
Fred


"dna" wrote in message
...
I am trying to log running/swimming times. I tried to filter the columns, but
it either keeeps rounding the numbers or changing it to a time.
thanks for help!!
--
dna

numbers are changes when input
 

Either use a custom format of "mm:ss.00", or prefix the time entry with a
single quote to force it to be interpreted as text.

Jerry

"dna" wrote:

Hi Fred,

How can I get the times (swimming/running) in the appropriate columns
without them changing themselves? For example the swim record 05:54.96
either rounds or changes to a time. I have tried to clear/ change with
filters.
Thanks!
--
dna

numbers are changes when input
 

If you enter 05:54.96 in a cell, Excel will display the result in the format you
have chosen, or by default to one decimal place. If you don't like what's
displayed, change the format. I suspect the format you want is mm:ss.00. Right
click on the cell, choose Format Cells..., choose Custom for Category, and enter
mm:ss.00 for Type.

--
Regards,
Fred


"dna" wrote in message
...
Hi Fred,

How can I get the times (swimming/running) in the appropriate columns
without them changing themselves? For example the swim record 05:54.96
either rounds or changes to a time. I have tried to clear/ change with
filters.
Thanks!
--
dna


"Fred Smith" wrote:

Thanks for the thanks, but do you have a question? Tell us the output you are
looking for, and the input you have, and you will surely get an answer to
your
question.

--
Regards,
Fred


"dna" wrote in message
...
I am trying to log running/swimming times. I tried to filter the columns,
but
it either keeeps rounding the numbers or changing it to a time.
thanks for help!!
--
dna