date format in [mm/dd] format [SOLVED]

[sunnyp]

date format in[dd/mm] format

 

[SirJB7]

Hi, sunnyp!

Wanna edit your original post if sent it incomplete, or it's just that?

Regards!

 

[sunnyp]

i wanted to format date in[dd/mm] like [4/5] in parenthesis.

 

[trixits]

Highlight the row/column or select the cell.

Right-click and select "Format cells"


On the Number tab

Select Custom

Type: "[dd/mm]"

 

[Hui]

On top of what Trixits said above


you can simplify that as

[d/m]


Using: 5 April as a date

d will display the 5th as 5

dd will display the 5th as 05


m will display the April as 4

mm will display the April as 04


You can force the custom interpreter to ignore the [ & ] controls by slashing them out as above rather than using two "

 

[sdsurzh]

Hi,


One more option. Suppose your date in A1 apply =TEXT(A1,"mm/dd") is formula in B1.


Thanks,

SK