Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
worksheet
 
Posts: n/a
Default spread sheet should have fraction for format like 1/32 too

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 "I
Agree" 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 "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc
  #2   Report Post  
Posted to microsoft.public.excel.misc
LACA
 
Posts: n/a
Default spread sheet should have fraction for format like 1/32 too


- Format
- Cell
- Fraction
then choose your fraction option


--
LACA
------------------------------------------------------------------------
LACA's Profile: http://www.excelforum.com/member.php...o&userid=30381
View this thread: http://www.excelforum.com/showthread...hreadid=500943

  #3   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default spread sheet should have fraction for format like 1/32 too

For the fractions, try Format Cells, select the Number tab and choose
Fraction.

For converting a number to text, start with
http://support.microsoft.com/kb/213360/en-us

"worksheet" wrote:

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 "I
Agree" 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 "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default spread sheet should have fraction for format like 1/32 too

On Thu, 12 Jan 2006 18:25:02 -0800, worksheet
wrote:

I wish to have the format of fraction like 1/32, which I can not find it.


Format/Cells/Number/Custom Type: # ??/32


Also how to add words text on Excel ?


I don't understand what you are asking for.


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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I'm creating a simple spread sheet Jan in Excel Excel Discussion (Misc queries) 2 January 2nd 06 07:48 PM
Can I add more columns to a spread sheet or is limit 256 columns Piper Excel Discussion (Misc queries) 4 October 9th 05 08:27 PM
Excel Slow to open Spread Sheet from Explorer Charles Welty Excel Discussion (Misc queries) 0 October 5th 05 02:16 PM
How do I create a spread sheet w/a numerator/denomenator? Denise Excel Discussion (Misc queries) 4 May 18th 05 06:24 PM
Copying multiple sheets from one book 2 another and undertake spec Pank Mehta Excel Discussion (Misc queries) 14 March 16th 05 04:41 PM


All times are GMT +1. The time now is 03:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"