PureBytes Links
Trading Reference Links
|
Hi Tim
Highlight the cells you want to format, right click the mouse, select
FORMAT CELLS, select the NUMBER tab, select CUSTOM, highlight the
selection in the list that is "# ??/??" then in the box above the list
change is to "# ??/32" and that should do it.
Regards
Philip
----------
> From: Timothy Morge <tmorge@xxxxxxxxxxxxxxx>
> To: omega-list@xxxxxxxxxx
> Subject: Help with Spreadsheets and 32nds?
> Date: 07 October 1998 03:37
>
> Folks...
>
> I am trying to do some spreadsheet work to clarify a few ideas I have in
the
> bond markets. I want to use Excel [or any other spreadsheet program] and
I
> wondered if there is a way to deal with prices that will leave them in
32nds and
> also give me my answers in 32nds? There must be a way to do this, and I
hope the
> answer is so simple I'll feel follish when I read your tips...
>
> Thanks in advance for your help and comments.
>
> Best,
>
> Tim Morge
|