numbers are changes when input

D

dna

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!!
 
F

Fred Smith

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.
 
D

dna

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!
 
J

Jerry W. Lewis

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
 
F

Fred Smith

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.
 
Top