|
PureBytes Links
Trading Reference Links
|
If you type:
# ?/32
into the custom format you'll get: 113 24/32
there's proably a way to format it even further
Mike
Peter Iovanella wrote:
>
> 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!
|