Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting withing formula?
Hello--
In a cell, I have a formula concatenated with text, like this: ="The analysis reveals that " & <formula goes here & "blah, blah, blah..." As is, the number resulting from the formula has a ton of decimal places. I need to control that so that it displays the way I want. In some cases that will be with one or two decimal places, and in others with none, etc. It doesn't seem to recognize the Format function that is recognized in VBA code. Any suggestions? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting withing formula?
The equivalent function to Format in Excel is Text(Value, "Format")
So something like this... ="The analysis reveals that " & Text(<formula goes here, "0.00") & "blah, blah, blah..." -- HTH... Jim Thomlinson "ppsa" wrote: Hello-- In a cell, I have a formula concatenated with text, like this: ="The analysis reveals that " & <formula goes here & "blah, blah, blah..." As is, the number resulting from the formula has a ton of decimal places. I need to control that so that it displays the way I want. In some cases that will be with one or two decimal places, and in others with none, etc. It doesn't seem to recognize the Format function that is recognized in VBA code. Any suggestions? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting withing formula?
Ah! That's it! Thank you!
"Jim Thomlinson" wrote: The equivalent function to Format in Excel is Text(Value, "Format") So something like this... ="The analysis reveals that " & Text(<formula goes here, "0.00") & "blah, blah, blah..." -- HTH... Jim Thomlinson "ppsa" wrote: Hello-- In a cell, I have a formula concatenated with text, like this: ="The analysis reveals that " & <formula goes here & "blah, blah, blah..." As is, the number resulting from the formula has a ton of decimal places. I need to control that so that it displays the way I want. In some cases that will be with one or two decimal places, and in others with none, etc. It doesn't seem to recognize the Format function that is recognized in VBA code. Any suggestions? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimizing Jpegs withing an excel sheet | New Users to Excel | |||
Averaging Time withing Excel | Excel Worksheet Functions | |||
Which function to check any value existed withing a list? | Excel Worksheet Functions | |||
Help pulling info from other sheeting withing a workbook. | Excel Worksheet Functions | |||
Viewing Worksheets withing One Workbook | New Users to Excel |