month function

[delta]

i use office 2007 i will put formula to show month name but my problem is empty cell then formula result shown "january 1900" i need when cell is empty then formula result shown nothing. i attache the file for more description

 

[Smallman]

Hi Delta

Maybe something like:

=IF(A2="","",TEXT(A2,"mmm yyy"))

Take care

Smallman

 

[Debraj]

Another way.

* You can simply use formula as =A2
* Now you can format the Number Format as "mmm yyyy"
* It also work the same way.

 

[sgmpatnaik]

@deb

i need some information about your file that is when i follow the instruction by you then the blank columns are blank in the next column but when i try the same thing new file then i am getting Jan 1900

how it is happen did you give any other formats for that because when i try the same thing in another column then also i am getting the blank for blank columns in A:A

kindly explain

Regards

 

[Debraj]

OOPS.. my fault..

By Default my system setting is "Display Blank as Blank, not Zero"



Sorry ! it was my default setting, so forget to mention..
Thanks for cross-check..

 

[sgmpatnaik]

@deb

Thanks for your input, off course i know this but the OP has to understand how that will happen with out errors / Zero Values, other wise he stuck in there ????

Thanks

SP