[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Help with Spreadsheets and 32nds?



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