Thread: Prices from decimals to ticks
View Single Post
 
Old 11-17-2012, 08:08 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Rollie,

Try:
=INT(B1)&"-"&TEXT(INT(MOD(B1,1)*32),"00")&TEXT(ROUND(MOD(B1*3 2,1)*8,0),"0")

If you want to suppress the final '0' (eg 180-30 instead of 108-300), try:
=INT(B1)&"-"&TEXT(INT(MOD(B1,1)*32),"00")&TEXT(ROUND(MOD(B1*3 2,1)*8,0),"#")
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote