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
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
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