| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to convert list of formulas in text format to output value
I have a very large list of formulas in text format so the formula isn't
providing an output. I have to change the cell format from text to general and I have to click on the cell that contains the formula and then click on the formula bar and hit enter for the formula to work. I have a very large list of formulas in my worksheet so is there an easier way to do this? Here is how the formula actually looks in the cell: ='\\gaalpfps10\TN-Shared\Network\Network\Traffic\FrameLayouts\WTN\[WTN-501-Friendship.xls]Changes'!a3 Thanks! Jaret |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting text output within formulas | Excel Worksheet Functions | |||
| Convert list of events to calendar format | Excel Discussion (Misc queries) | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| How to convert fraction format to text format ...... | New Users to Excel | |||
| How do a convert a "text only (no formulas)" Excel (.xls) file to. | Excel Discussion (Misc queries) | |||
Threaded Mode
