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 seconds with decimal point at two digits.
| 4500 | 500 | 6500 | 1000 | 3100 |
| 3600 | 2000 | 6000 | 2500 | 2200 |
- 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
3 Replies
- 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
- 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
