|
PureBytes Links
Trading Reference Links
|
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
>>>
>>>
>>>
>>
>>
>
>
|