convert the figure crore

[ushaanu]

Hi all,

I want to convert the figure of 24714081 into 2.47 core.

thru formatting Option

thanks
Anu

 

[Khalid NGO]

Hi Anu,

Didn't found any way to format 24714081 as 2.47

But you can use @Nebu's formula:
=ROUND((A2/10000000),2)
or
=ROUND((A2/10000000),2)&" core"

Hope someone else will provide the way to format.

Regards,

 

[ushaanu]

Thank for the reply

actually in excel cell have already other formula so I need some way out thru formatting.

Thanks
Anu

 

[Khalid NGO]

Thank for the reply

actually in excel cell have already other formula so I need some way out thru formatting.

Thanks
Anu

So can you wrap your formula with ROUND?
something like:
=ROUND(SUM(A1:A10)/10000000,2)&" core"

 

[John Jairo V]

Hi to all!

Please check this:
http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/

Blessings!

 

[John Jairo V]

Hi... This can be a way for do it... with a "tricky" part.
Check the file please! Blessings!

Edit: Check the link with Explanation.
http://chandoo.org/wp/2012/01/31/custom-number-formats-multiply-divide-by-any-power-of-10/

 

[Khalid NGO]

Hi @John Jairo V
That is great...

What is the "Tricky Part"?


When i use format painter, result is same but, when i copy your custom format to any new cell,
Why "%" is reflecting at end?
Even at the type area...



Your clarification is required.
Regards,

 

[ushaanu]

hi I think this is the Trick!!!


thank

anu

 

[ushaanu]

 

[John Jairo V]

Hi @Khalid NGO

If you read the link with explanation, you could see the "tricky" part. Press Ctrl + J before the "%", format up vertically and decrease the high of the row. ¡That's it! Blessings!

 

[Khalid NGO]

Hi @Khalid NGO

If you read the link with explanation, you could see the "tricky" part. Press Ctrl + J before the "%", format up vertically and decrease the high of the row. ¡That's it! Blessings!

Thanks John for the clarification.
Thanks Anu.

Happy learning