JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,534
- Office Version
- 365
- Platform
- Windows
I've used the Convert function many times. For some reason, it fails when I try to convert miles/hour to meters/second:
<tbody>
</tbody>
Now what am I doing wrong?
The 60s in Col C are formatted as General. I also tried them as Number, but it still fails.
R/C | C | D | E |
4 | mi/hr | m/s | formula |
5 | 60 | #N/A | D5: =CONVERT(C5,"mph","m/sec") |
6 | 60 | #N/A | D6: =CONVERT(C6,"mph","m/s") |
<tbody>
</tbody>
Now what am I doing wrong?
The 60s in Col C are formatted as General. I also tried them as Number, but it still fails.