Convert cell value in Yards to Miles,Furlongs,Yards

[xluserg]

Hi all

Googled with no joy.

How could I convert a cell with the value in yards 1980 to read 1M 1F and if the value was 1981 to 1M 1F 1Y......... meaning 1Mile 1Furlong 1Yard

I've a column of many different numbers ranging from something like 1094 to 7554

hope I've been clear in my post.


Thanks all

Graham

 

[Fluff]

Not very pretty, but how about

Book1
	A	B
1
2	1759	0M 7F 219Y
3	1980	1M 1F 0Y
4	1981	1M 1F 1Y
5	1094	0M 4F 214Y
6	7554	4M 2F 74Y
Data

Cell Formulas
Range	Formula
B2:B6	B2	=INT(A2/1760)&"M "&INT(MOD(A2,1760)/220)&"F "&INT(MOD(MOD(A2,1760),220))&"Y"

 

[xluserg]

Hi Fluff

Very nice Fluff. I can work with that! you've saved me a lot of time.

Thanks Fluff

All the best for Christmas and the New Year.

 

[Fluff]

You're welcome & thanks for the feedback