Re: Excel decimal to bond tick question

["Peter Iovanella" <ivo1@xxxxxxxxx>]

Thanks - do you know if there is any way to make it appear like 124^13
rather than 124 13/32?  And I had to make a custom format, as Michael Joyce
suggested, since there isn't an ??/32 one provided with Excel.

Peter


-----Original Message-----
From: Mark Brown <markbrown@xxxxxxxxxxxxx>
To: Peter Iovanella <ivo1@xxxxxxxxx>; omega-list@xxxxxxxxxx
<omega-list@xxxxxxxxxx>
Date: Monday, November 23, 1998 1:59 PM
Subject: Re: Excel decimal to bond tick question


>
>click on the cell then hit format then choose fraction pick what you want,
>click ok...done...next?
>
>
>>Format them how?  I mean, do I have to create my own custom format, or is
>it
>>included within Excel?
>>
>>
>>-----Original Message-----
>>From: Mark Brown <markbrown@xxxxxxxxxxxxx>
>>To: Peter Iovanella <ivo1@xxxxxxxxx>; omega-list@xxxxxxxxxx
>><omega-list@xxxxxxxxxx>
>>Date: Monday, November 23, 1998 1:45 PM
>>Subject: Re: Excel decimal to bond tick question
>>
>>
>>>yes you can do it in excel , format the numbers dude!
>>>
>>>
>>>
>>>-----Original Message-----
>>>From: Peter Iovanella <ivo1@xxxxxxxxx>
>>>To: omega-list@xxxxxxxxxx <omega-list@xxxxxxxxxx>
>>>Date: Monday, November 23, 1998 12:38 PM
>>>Subject: Excel decimal to bond tick question
>>>
>>>
>>>>Is there any macro out there that will allow me to see prices I import
>>into
>>>>Excel from TS in terms of ticks rather than in decimal form?  For
>example,
>>>>how I can get 113.75 to appear as 113^24.  I assume that TS has some
>>>>built-in routine to do this; is there anything I can do in Excel to
>>emulate
>>>>this?  Thanks!
>>>>
>>>>BJ
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>