In Excel 2010, how can I convert milliseconds to seconds (ss.00) on the fly as I type the data into the specific cells?
i.e.
123456 milliseconds = 123.55 seconds
thanks!
Thanks,
REMGU
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Otherwise, you’ll need a Worksheet_Change macro that will monitor changes made to the cells and replace what is manually entered with the converted value.
This will perform the conversion on any number entered in Column A:
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.