customize number format

[vinod9111]

Dear All,

Simple question, am stuck in a customizing the number format. Got a column of data where the numbers are in actul (10000000) and i want it display it in crores (1). Tried to work around in custom numbers in format cells but was not successful. your help will be appreciated.

regards

 

[sudeep]

This worked for me:

http://www.mrexcel.com/forum/showthread.php?t=51952

 

[vinod9111]

Thanx sudeep for you reply, but am looking for something different

input cell would be After formatting the number it should look like
10000000 1.00

Well it can be achieved by dividing through paste special but i dont want to change the actual numbers.

regards

 

[vinod9111]

Sorry for the last post, could not provide the clear picture. given below is table my input cell is the figures in crores and post customizing the nunber formatting it should look like output cell.


<TABLE style="WIDTH: 237pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=315 border=0 x:str><COLGROUP><COL style="WIDTH: 130pt; mso-width-source: userset; mso-width-alt: 6326" width=173><COL style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 5193" width=142><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 130pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=173 height=17>input cell</TD><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 107pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=142>Output cell after formatting</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right height=17 x:fmla="=10^7" x:num="10000000">10000000</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>1.00</TD></TR></TBODY></TABLE>

hope am able to provide the clear situation.