Tag Info

New answers tagged

0

You can use a function to convert the duration to a plain number. For example, if difference between the dates in in E4, and it's 10 days, then... =DUR2HOURS(E4) × 0.1 Shows a number, 24.0. There are other functions that you might use: DUR2DAYS, etc.


0

Turns out you have to wrap every formula that generates a duration in DUR2DAYS or DUR2HOURS to convert to a number.


0

Select the columns with the data that you want to preserve. Choose Copy from the Edit menu (or hit Command ⌘+C). Choose Paste Formula Results from the Edit menu (or hit Shift ⇧+Command ⌘+V). You should end up with just the results of the formula.


0

It depends on what you are trying do do with the spreadsheet but putting <'> (single quote) in-front of the leading zero will preserve it with the conversion from CSV to xls format. As @Alex says converting the cells to text will work, and inserting the single quote at the start of the cell just converts it to text.


0

From the Home tab, select the cells you wish to format, and from the format drop-down under Number select Custom. Or, right-click and choose Format Cells, or hit Cmd-1. This will pop-up a dialog window with the various formatting options. Again, make sure you're on Custom. In the Type box type in: 000000 Click Ok. Alternatively - change the formatting ...


1

It works by dereferencing the value of a cell directly to the condition Example: SUMIFS(Daily Log::Income,Daily Log::A,">=2014-07-01",Daily Log::A,"<2014-08-01") Referencing the cell could also be made possible with the same construct; by adding ampersand followed by the cell name outside the double quotes. Example: SUMIFS(Daily Log::Income,Daily ...


1

I don't know if it's possible to do this with functions, but it might be. There is a function called VLOOKUP that seems like it would do what you want, but I couldn't get it to quite work in my experimenting with it—a function that exists within one cell has a hard time returning multiple values for multiple cells. What I think does work, though perhaps not ...


0

In any program to find out what fields/data can be inserted at a given point look for the menu item "Insert" if there is one you will see under that menu diffent types of data that can be inserted. I pages you can "Insert" any of the information from the Addressbook. In numbers it is much more limited. AppleScript is most probley to best solution for ...


0

Here is what I got using six VLOOKUP =CONCATENATE(VLOOKUP(2,Hm_Roster::A3:E8,3,FALSE),(" "),VLOOKUP(2,Table 1::A3:E8,2,close-match),(" "),VLOOKUP(6,Hm_Roster::A3:E8,2,FALSE),(" "),VLOOKUP(1,Hm_Roster::A3:E8,4,FALSE),(" "),VLOOKUP(5,Table 1::A3:E8,2,close-match),(" "),VLOOKUP(2,Hm_Roster::A3:E8,4,FALSE)) The search is being done across two sheets. And ...



Top 50 recent answers are included