|
I have a problem with a CSV file which has telephone numbers stored in their internationalized format (+1-800-555-1234). When opening this CSV in Excel 2007, it converts that data to a formula and displays the result (=1-800-555-1234; resulting in -25...
Started by DLux on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at superuser):
-JFV
use TEXT Method =TEXT(B1,"+1-800-555-1234")
Open a blank worksheet then select... .
Or put " " around the data that you want to be viewed as text in the CSV file .
Right-click on the cell --> choose 'Format Cell' --> Select under 'Category:' Text .
|
|
I have a situation where i need to put a formula in the "Value_if_true" and "Value_if_false" fields in an IF function but it does not seems to be working. It just keeps displaying my formula as is in the cell. Can someone help?
Started by Garima Kumar on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Just....
You can put a formula in another cell and point the if statement to that cell for the result like so:
A1 =IF(B1, IF(B2, B3, B4), B5)
As you've now provided the formula, i'll fix it:
=IF(I5=0,(12-BC5)*BE5 + BH5,BF5)
should work
Um...
|
|
A field in excel contains words seperated by semicolons
e.g
A1 = save;the;national;treasure;for;good
how can i apply excel text formula to produce seperate words from this field in another field
e.g
a2 should conatain a formula to result the first word...
Started by silverkid on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You can create a VBA function to split the fields from this example :
Function ExtractElement(str - 1) Else ExtractElement = "" End If End Function
Then the A2 formula would be: =ExtractElement(A1, 1 your text to parse in A1 then the following....
|
Ask your Facebook Friends
|
Hi all,
Guys, I am using SQL Server 2000 and executing the sp_columns stored procedure to get a layout of my table. One of my fields is a formula field and my question is, how can I determine this through sp_columns? sp_columns does not seem to show this...
Started by icemanind on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Create table #results( TABLE_QUALIFIER sysname, TABLE_OWNER sysname, TABLE_NAME sysname, COLUMN_NAME sysname, DATA_TYPE smallint... .
You could dump the results of sp_columns to a temp table, and then add on the ColumnProperty function to the results of that.. .
|
|
I have a simple formula in crystal syntax which looks something like this :
if isdate(totext({Absence Details.Return to Work Interview Date})) = true and {Absence Details.Return to Work Interview required} = true then 1 else 0;
This is the actual code...
Started by Amit on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Of course, if that doesn't print out 7 's, then feel free to ... .
A bit with others) will leave fields blank if they're zero - this often helps in reading the report the output field or even stting it to a textual "0" instead of numeric 0 .
|
|
I'm pretty sure that the sequences like are not traces of elementary functions on positive integers (take any reasonable definition of "elementary" you want, just make sure that all high school formulae are there). However, the usual proofs of non-elementarity...
Started by fedja on
, 7 posts
by 5 people.
Answer Snippets (Read the full thread at artofproblemsolving):
And you basically meant beat them in a football match, didn't you? The formula make heavy use of differential fields....
Yes storm.
formula".
|
|
I have a sharepoint list
with 2 users for examole (user A and user B)
i need a calculated field in the list items such that if user "A" created the item the field vaule will be "X" and if user "B" created the item fields value would be "Y"
but i couldnt...
Started by Ali on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
The field can be hidden from the user inside the editI believe you can create a text field that has the default value set to [Me] which should then be usable in a calculated field....
Control to set the fields to what you desire.
|
|
I've got a problem in Crystal Reports that's been bugging me for years, and I wondered if anybody might have a solution. I've got a few fields (data fields and formulae, numeric and string) all aligning to the left in design mode.
When I move to preview...
Started by JamesW on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Design entire report on same computer - this is not joke; different computers may have numeric fields....
Use exactly same fonts for all fields, use guidelines to align fields.
Using formulas and display formula results.
|
|
Can you use calculated fields in Excel 2007 pivot tables when the data source is an SSAS data cube?
I am connecting to a SQL Server 2005 data cube with Excel 2007 and viewing the data though a pivot table. I want to create calculated fields in my pivot...
Started by Craig HB on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Jim Thomlinson
You can ....
Since XL is not in charge of the aggregations it has no ability to do custom calculations.HTH.. .
All of the aggregations are handled by Analysis Services.
This is the answer I got from MSDN:
Not possible.
Looks like you can't.
|
|
I'm nedding to implement excel formula autofill in C#.
Let's suppose this formula is located at B100:
=SUM($B$99:B99)
I want to make this formula different at C100:
=SUM($B$99:C99)
This formula is only an example. Some real examples are:
=(SUM($B${0}:...
Started by Victor Rodrigues on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
In other words!" // not a ....
Maybe once you digest all the rules for tokenizing a formula, you'll not verify what you're feeding it is a formula - I take it you're only using formulas.
Develops/2004/12/excel_formula_p.html .
|
