How to Convert numbers into thousands, lakhs, millions and crores in excel? #Excel #Learningoftheday

preview_player
Показать описание
How to Convert numbers into thousands, lakhs, millions, and crore in Excel?

1)Convert into '000s
First type 1000 in separate cell and Copy 1000
Then Select numbers and Paste Special,
Select Values and Divide,
Click OK.

Similarly for other denominations.
Рекомендации по теме
Комментарии
Автор

You've solved a very big problem thankyou so much 😊

inspectorsiddarthruriya
Автор

Thanks a lot, dear stranger. It made my work so easier.

bishwodarshan
Автор

Thanks for this, this made very easy for me to conver the balance sheet rounding off

ankitjaiswal
Автор

This video help me today in office, thanks Har Har Mahadev 🔱

chandankalita
Автор

Why did you stopped making more videos?

Shriraj
Автор

How to display a number which is 1, 000, 000, 000 as 1b or 1B. Or may be a 1, 350, 000, 000 as 1.35b or 1.35B without dividing the number.

Can we set a formula in a cell to show 1, 000, 000, 000 as 1b?

mehmudasif
Автор

I want it show like this 10, 000 not 10, 000.00
How to do that ?

iZacq
Автор

how to convert the negativve numbers??

jessamaecollo
Автор

How to make chart of these values ? Ma'am

n.dnrityakala
Автор

While this is a good trick, is there any way to make this dynamic??

dakshbhatnagar
Автор

Please add more videos, informative ones.

bishwodarshan
Автор

Why you Put on these numbers bellow....

masudalam
Автор

Thanks a million.. otherwise I suppose to to calculate one by one whole night😂

kingsonengti
Автор

How to convert any figure which is thousands to crore and vice versa like thounsand in crore and vice versa

DESTINY-rmsh
Автор

This video does not receive any voice. Please re-post the same with audio.

shripadyashwantkulkarni
Автор

Bernardus Khan TV news radio FM rainbow all Indian namaskar thank you for your money for all OMc AMC roll once again all'OMc AMC roll I'm Caen all hege teke on YouTube ok atm 👁️ on 1995 all

bernarduskkhan