|
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 .
|
|
Hi,
I Want to know How to get Formula Fields in Visualforce page in Outputtext or outputField .
I have tried to retrive Formula fields in noraml way like
<apex:outputtext value="{!objname.formulafieldname}"/>
All other Fields are getting Values...
Started by raju123 on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at sforce):
Is there any Function for....
Regards,
Kiran Hi Kiran,
My Req, I want to check a variable as Number or not in Controller not in javascript .
U need to query and get that value...
If it is a direct access from the object with out quesying u wont get that. .
|
|
Hi,
I Want to know How to get Formula Fields in Visualforce page in Outputtext or outputField .
I have tried to retrive Formula fields in noraml way like
<apex:outputtext value="{!objname.formulafieldname}"/>
All other Fields are getting Values...
Started by raju123 on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at developerforce):
Certified Force.com Developer, Certified Administrator
Kiran Hi Kiran,
My Req, I want to check a variable as Number or not in Controller... .
U need to query and get that value...
If it is a direct access from the object with out quesying u wont get that. .
|
Ask your Facebook Friends
|
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...
|
|
Hi
I have some problem crystal report by formula field
I want to display full record with length as defined in data structure without any trims as field position get violate as there is any change in preceding field
for example
sub m1 m2 m3
11 g1 a2 a...
Started by kkshansid on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at codeguru):
|
|
Hi,
I am designing the report like
Customer , year, GL indicator, D/C indicator, Amount
Here I required create the formula fields like
Trade
(if {GL Indicator}="T" and {D/C Indicator}="D" then Amount) - (if {GL Indicator}="J" and {D/C Indicator}="C" then...
Started by sriramreddy on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at forumtopics):
|
|
I'm trying to set up a formula that will compare the Street field in the Leads tab to the Street field (Custom Field) in a Custom Object. If they match, the formula should return a third field (another customer field in the the Custom Object).
What i'...
Started by -MD on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at sforce):
|
|
Hi there,
I'm trying to create a formula field for tasks so that I can show the contact name, Account name and a description of the task.
I can't seem to show that information.
Anybody have any ideas?
Thanks!
Tia
Started by TiaPheno on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at developerforce):
|
|
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 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.
|
