Prices from decimals to ticks

		Microsoft Office Forums > Microsoft Excel > Excel
Prices from decimals to ticks

FAQ

Thread Tools

Display Modes

11-17-2012, 08:08 PM

macropod

Windows 7 64bit Prices from decimals to ticks

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,514

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]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Charting Help - Stock Prices	Ligerdub	PowerPoint	0	01-03-2012 04:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:08 AM.