cell formating

[faizee]

Can anybody help me in number formating
i want to set cell format to 23432/22
Right now my cell custom formating is #,###.00
but i dont need decimal. i need "/"
like #,###"/"00
what shoudl i do.

 

[pboltonchina]

Enter it as text with an apostrophe ' in front of it

 

[faizee]

i think its not a good idea,
i want.

when i enter 23322.42, it appears in cell as 23,322/42

 

[pboltonchina]

I'm using Excel 2007 and with the cell format set at default or with an apostrophe, I get 22432/22 displayed OK