cell formating

faizee

Board Regular
Joined
Jan 28, 2009
Messages
181
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.
 

faizee

Board Regular
Joined
Jan 28, 2009
Messages
181
i think its not a good idea,
i want.

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

pboltonchina

Well-known Member
Joined
Apr 24, 2008
Messages
1,095
I'm using Excel 2007 and with the cell format set at default or with an apostrophe, I get 22432/22 displayed OK
 

Forum statistics

Threads
1,085,429
Messages
5,383,628
Members
401,843
Latest member
stevensmith1

Some videos you may like

This Week's Hot Topics

Top