View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jeff Stevens
 
Posts: n/a
Default How do I create a viewable formula using calculated fields?)Excel

The following fomula should work for you:

=TEXT(A1,0)&"/"&TEXT(B1,0)


"JohnH" wrote in message
...
I need to build a fileld in an Excel Spreadsheet which shows 2 other
calculates field values in a simple statement. (ie: A1 = X1 + Y2 and B1 =

R4
/ V20 such that the computed value of A1 may = 350 and B1 may = 450... I
want to show in another cell, such as C1 the computed values in a formula
ie: C1 = "(350 / 450)" will be visable, not treated as a formula and
computed. I hope this is somewhat clear.