="=ROUNDUP("&"50.42"&",0)"
I take this paste text only to get:
=ROUNDUP(50.42,0)
this wont work normally until i open the cell and press enter.
Any way I could do that for more than 1 cell at a time?
="=ROUNDUP("&"50.42"&",0)"
I take this paste text only to get:
=ROUNDUP(50.42,0)
this wont work normally until i open the cell and press enter.
Any way I could do that for more than 1 cell at a time?
I am unable to understand what you are trying to do
What is the use of & symbol in your formula?
Please explain
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
are they in any sequence?
in 1 column?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
I am crafting the formula with other formulas... The problem is when i paste text only, and get with the final formula it won't trigger.
Just try it.
Copy the first thing in my first post. and paste text only.
Now you get a formula.
How do i get that to work other than opening a cell and pressing Enter.
P.S.
Ye they are usually in columns.
Last edited by Polymorpher; 06-13-2014 at 03:16 AM.
if they align in one column
you can text to column>finish and all the cells should update
Seems like you are using the new function introduced in 2013 (i.e.) FormulaText() which will get the formula used in another cell.
So Copy pasting the arrived formula will put the formula as text. Pressing F2 and enter will convert the Text formula to act as a formula.
Am I right?
If so select the range (Only one Column Range) Press Alt+D+E and Press Next and Press Next and Click Finish
cool, between that and transponse I think I'll be ok.
You'd think just changing the cell format would get it to trigger.
Thank you.
Last edited by Polymorpher; 06-13-2014 at 03:29 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks