Remove hyperlink formatting from address

Another way to do this without clicking in each cell would be to use the =HYPERLINK() function.

Here are some steps:

• Add a second column (Let's call it B)
• In the adjacent cell, add a formula like this: =HYPERLINK(A1)
• Drag the formula down

Provided that the original URL's are valid, this will convert them.

You can even add your own text in place of the URL. (see screenshot)

So, given column A has a long list of URL's starting in cell A1, then in B1 enter:

=HYPERLINK(A1,"Clickable Link")

One could even parse the original URL to get just the human readable part using MIDDLE() or similar.

Hope this helps!! Sample Numbers Formula for Hyperlink

I believe Insert > Date & Time (and its two companions) are intended for use in headers and footers. These are available after choosing File > Print. When used there, the inserted date can be clicked for a little popup formatter and button to manually reset the time to now.

The feature you want, an auto-generated NOW cell that does not change, is apparently not available.

Option A: Put the NOW function into a cell somewhere. It shows the current time. Copy the cell, then Edit > Paste Formula Results into the cell you want to have the unchanging time.

Option B: Use a general macro app (like the amazingly capable Keyboard Maestro) to generate your date/time text and paste it into a cell.

In both cases, choose the date and time formats you want on the final cell.

(Numbers 3.5.3 used for this answer)