Forum Discussion
Solved
Excel 2007, Converting microseconds to seconds in multiple cells all at time.
Hello, looking to see how to convert a group of cells from microseconds to seconds. Example: 4000 to 4.00, 15200 to 15.20 --- the below cells are in microseconds and I need to convert them to seco...
- I guess you meant milliseconds.
Enter 1000 in a cell, select it and type Ctrl-c
select your raw data (in milliseconds)
click Paste>Special Paste, select Division and hit Enter
That will divide all your numbers by 1000
Now, format your data as numbers with 3 decimal places<;
That's it!
HTH,
--
LR
Select any empty cell and enter 1000 into it. Copy that cell. Now select all cells with microseconds and choose Paste Special and select the Divide option.
Your method saved me a ton of time!
Thank You very much
JFP Vendmaster
Thank You very much
JFP Vendmaster