Re: How do I format Concatenate function?
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
One way:
=TEXT(A1,"0'-") & TEXT(C1,"0 ?/?\""")
In article <8BB77A48-49F5-4B02-905C-C1C8F370206C@xxxxxxxxxxxxx>,
deepc <deepc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
My goal is to combine 2 values that are calculated in their respective cells
into one string.
What I have is the number '2' in cell A1 and the number '3 1/8' in cell B1.
I want to come up with the text 2'-3 1/8" in cell C1. My problem is that the
inches part of it comes out in decimals, not as a fraction, ie. I get
2'-3.0625" instead. What is the easiest way to solve this? I've got thousands
of cells to convert.
.
Relevant Pages
- RE: Converting a fraction to decimal
... Public Function FractionToDecimal(txtFraction As String) As Single ... 'Element 1 is left side of the fraction ... You can change the formatting to suit yourself, but the leading # in format ... I would like the user to enter inches and then ...
(microsoft.public.access.forms) - Re: convert fractions to decimals
... Public Function CvFraction(strFrac As String) As Double ... If you want to allow users to enter either a fraction or an ... >>bob gee wrote: ... >decimals. ...
(microsoft.public.access.formscoding) - Re: How do I format Concatenate function?
... into one string. ... inches part of it comes out in decimals, not as a fraction, ie. ...
(microsoft.public.excel.misc) - Re: An uncountable countable set
... repeating decimals, ... that is every digit in that string is in a finite position with respect ... finite strings you call naturals. ... mind that the set of such finite string representations of infinite ...
(sci.math) - Re: More on intonation
... are they the same string length? ... elimination of the so-called "wolf notes", ... of the guitar that follows the internal contour of the body and is ... about 4 inches out. ...
(rec.music.classical.guitar) |
|
