View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
jmer jmer is offline
external usenet poster
 
Posts: 2
Default Convert Ft'-In Fr" (5'-6 3/4") to Ft.dec (5.56)

Now is there a way to reverse that? If I have 5.56 can I convert it to read
5'-6 3/4"?

"Bernard Liengme" wrote:

Good to know.
Thanks for the feedback.
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"sammy" wrote in message
...
Thank you Bernard,

This is exactly what i wanted and i have done some testing with know
values
and it works as expected.

Thanks again.
Sammy