Forum Discussion
Piuff
Jan 28, 2026Copper Contributor
Excel formel
I am going to, have the same date pasted in about 50 places for labels. Request: I did Create a cell, AL2 - wrote, 27 Oct Then I want to create a formula in the 20 different places, that picks up...
Harun24HR
Jan 28, 2026Bronze Contributor
You may need TEXT() function to display a proper format as your input value is date. Try-
=TEXT($AL$2,"dd mmm")