CODEWITHSUNDEEP
excelfunctiondateformat
thanos.a
thanos.a

Reputation: 2684

Excel text function always returns the format

I'm trying to retrieve the month as text from a date cell using the text() excel function as follows:

A1 -> 17/03/2013

A2 -> =TEXT(A1; "mmmm")

A2 (result) -> mmmm

The expected result is "March", but what I get is what I enter as format "mmmm".

Notes: the A1 cell is declared as date so what I really see is a well formatted date such as "Sunday, 17 March 2013".

Upvotes: 3

Views: 385

Answers (1)

alpha bravo
alpha bravo

Reputation: 7948

you need to change your Date format in the Region and language under control panel to dd-MMM-yy or change A1 cell value to 03/17/2013

Upvotes: 0

Related Questions