Is there a way in formula to convert a number from a tenth of a second to a fifth of a second? I am trying to convert numbers such as 12.8 into 12.4 or 50.6 into 50.3.
Any thoughts are appreciated.
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
=TEXT(A1;"#_ ?/5")
pecoflyer wrote:I can't seem to get your solution to work
Leaving the space before the question mark returns an error. If I omit the space I get 64/5 for 12.8.
Can this be due to regional settings ?
Return to General Excel Questions
Users browsing this forum: No registered users and 248 guests