| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i input numbers so they subtract from a total in a row | New Users to Excel | |||
| Sum of Numbers Smaller than input | Excel Discussion (Misc queries) | |||
| Sum of Numbers Smaller than input | Excel Discussion (Misc queries) | |||
| How do I input numbers used to select cells in several columns | Excel Discussion (Misc queries) | |||
| Macro for user to input 10 numbers | New Users to Excel | |||
Hybrid Mode
