carl swanstrom
New Member
- Joined
- Oct 27, 2002
- Messages
- 2
I have tons of data downloaded from a new process. Column B contains the time with the seconds in decimal format (eg. 00:12:08.310
). Excel will not allow me to reformat the cells and my boss wants graphs with time he can understand. I accidently found that if I hit "edit" (F2) and then enter, the value is now in a format that Excel will let me reformat. GREAT! However, I can not figure out how to write a macro that does this for 1440 rows. Making sure the I am using relative references, I try recording a macro by hitting F2 then enter five times. I run the macro and it does aexactly what I need for five rows. However, if I try to run it again for the next five rows, it puts the values for the first five rows in, Please help. I am sure this is very simple, but I am very new to writing successful macros.
Thanks for any help.
). Excel will not allow me to reformat the cells and my boss wants graphs with time he can understand. I accidently found that if I hit "edit" (F2) and then enter, the value is now in a format that Excel will let me reformat. GREAT! However, I can not figure out how to write a macro that does this for 1440 rows. Making sure the I am using relative references, I try recording a macro by hitting F2 then enter five times. I run the macro and it does aexactly what I need for five rows. However, if I try to run it again for the next five rows, it puts the values for the first five rows in, Please help. I am sure this is very simple, but I am very new to writing successful macros.
Thanks for any help.