Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
Lista Forumurilor Pe Tematici
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login

POZE MRRRR'S FORUM (VIEW ONLY)

Nu sunteti logat.
Nou pe simpatie:
Jasmmyne la Simpatie.ro
Femeie
22 ani
Bucuresti
cauta Barbat
22 - 34 ani
Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Insert Text with Date Formula in the Same Cell [TEXT] Moderat de TRaP, TonyTzu
Autor
Mesaj Pagini: 1
TonyTzu
Moderator

Inregistrat: acum 12 ani
Postari: 252
For some reason in a table header you would like to import a date, for example when having a column that takes material inventory from another sheet, it would be useful to have the date of the inventory in the header of that table, to always know if the dates are actual.

="Inventory at: "&TEXT(INVENTORY!U1;"dd.mm.yyyy")

This displays:
Inventory at 21.06.2018
in your table header cell. It doesn't matter how that cell is formatted (text, number etc.)


pus acum 5 ani
   
Pagini: 1  

Mergi la