I wish to have the format of fraction like 1/32, which I can not find it.
Also how to add words text on Excel ?
I need a work sheet with both words and numbers
Thanks
June Li
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.
www.microsoft.com/office/comm...lic.excel.misc
- Format
- Cell
- Fraction
then choose your fraction option--
LACA
------------------------------------------------------------------------
LACA's Profile: www.excelforum.com/member.php...oamp;userid=30381
View this thread: www.excelforum.com/showthread...hreadid=500943For the fractions, try Format gt; Cells, select the Number tab and choose
Fraction.
For converting a number to text, start with
support.microsoft.com/kb/213360/en-us
quot;worksheetquot; wrote:
gt; I wish to have the format of fraction like 1/32, which I can not find it.
gt;
gt; Also how to add words text on Excel ?
gt;
gt; I need a work sheet with both words and numbers
gt;
gt; Thanks
gt;
gt; June Li
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc
On Thu, 12 Jan 2006 18:25:02 -0800, worksheet
gt; wrote:
gt;I wish to have the format of fraction like 1/32, which I can not find it.
Format/Cells/Number/Custom Type: # ??/32
gt;
gt;Also how to add words text on Excel ?
I don't understand what you are asking for.
gt;
gt;I need a work sheet with both words and numbers
Again, this is very unclear. Almost every worksheet I've seen has words and
numbers. Maybe there is a language problem?
--ron
- Jun 22 Fri 2007 20:38
spread sheet should have fraction for format like 1/32 too
close
全站熱搜
留言列表
發表留言