need to change month format in excel

January 24, 2011 at 23:32:25
Specs: Windows XP
i have a month as "9" need to change MMM in format it is changing to "jan" instead of "Sep", please advice how.

See More: need to change month format in excel

Report •


#1
January 24, 2011 at 23:58:32
There might be an error either on the program, or the computer.
Try restarting the computer and open excel again. It never happended to me.

Report •

#2
January 25, 2011 at 01:10:12
its taking as 01/01/1900

Report •

#3
January 25, 2011 at 01:22:25
It sounds like it doesn't know that the value is actually a Date.

Does it happen to all dates or just this one?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
January 25, 2011 at 01:49:28
TO ALL SINGLE DIGITS

Report •


Ask Question