Month Formula =TEXT($D$2,"mmm") doesn't work on all column

[caos88]

Hello all,

i am trying to apply the formula =TEXT($D$2,"mmm") to identify the month to the entire column but unfortunately it doesn't work and is actually giving me the same month for all.
How to make the formula working for all the cells in once?

 

[MARK858]

Try removing the $ in front of the 2 i.e. =TEXT($D2,"mmm")

 

[caos88]

Try removing the $ in front of the 2 i.e. =TEXT($D2,"mmm")

OH...did't know was so simple. Thank you, it works great.

 

[MARK858]

You're welcome.
Just so that you are sure what is happening, the $ fixes/locks the reference so $D fixes/locks the formula to column D and $2 fixes/locks the formula to row 2.

 

[caos88]

You're welcome.
Just so that you are sure what is happening, the $ fixes/locks the reference so $D fixes/locks the formula to column D and $2 fixes/locks the formula to row 2.

Perfect......sorry about that, i have much more to learn.

 

[MARK858]

Happy it helped and no need to apologise, we are here to try and help answer questions