What about this:
=TIME(,,A1)

Format as:
mm:ss


HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Katie" wrote:

I want to change data that is just a normal number into mins and seconds.
e.g. 80 --- 1:20 or 1.20 or something, so it is recognisable as 1 minute 20
seconds

Katie.