Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Elena
 
Posts: n/a
Default How do I write the fraction "1/n" ?

How can I write "1/n" ??
  #2   Report Post  
Michael
 
Posts: n/a
Default

Hi Elena
Select
Format/Cells/Number and select Fraction.
Then simply type in 1 / n

HTH
Michael

"Elena" wrote:

How can I write "1/n" ??

  #3   Report Post  
Bob Tarburton
 
Posts: n/a
Default


Just using my imagination here.
Are asking how to represent a vaule as "1/n"?

If you have a value in A1
="1/"&1/A1
If A1=4, this returns 1/0.25
or if if A1=0.25, this is 1/4

If this is what you're looking for you might to use a round on A1
="1/"&1/round(A1,<#ofdigits)

I'd be curious to hear if there is a way customer format this.



On Sun, 27 Feb 2005 13:59:01 -0800, "Elena"
wrote:

How can I write "1/n" ??


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
How do I write the fraction "1/n" ? Elena Excel Discussion (Misc queries) 3 February 27th 05 10:27 PM
Write Contents of TextBox to new Workbook Andy Tallent Excel Discussion (Misc queries) 0 February 21st 05 11:45 AM
how to write to other sheet if and only if? Len Canders Excel Worksheet Functions 10 February 16th 05 03:08 AM
How do I write formula to compare two values and pull the resulta. Renee Excel Worksheet Functions 1 February 11th 05 01:31 AM
how do i write a formula and keep in in formula form, so it DOESN. norcalchick2207 Excel Discussion (Misc queries) 2 February 4th 05 08:38 PM


All times are GMT +1. The time now is 05:32 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"