Question description:
This user has given permission to use the problem statement for this
blog.
hello, if i type 55 cr in numbers then it appears 550,000,000 but earlier in my old HP LAPTOP IT WOULD APPEAR AS 55,00,00,000. now i require in 55,00,00,000 format. please help
Solved by E. C. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
22/08/2018 - 08:03
Hello
Excelchat Expert
22/08/2018 - 08:03
How are you today?
User
22/08/2018 - 08:03
i am good
User
22/08/2018 - 08:04
pls help for the above text
Excelchat Expert
22/08/2018 - 08:04
Nice to hear that!
Excelchat Expert
22/08/2018 - 08:04
Is it possible for you to share you file?
User
22/08/2018 - 08:04
hello, if i type 55 cr in numbers then it appears 550,000,000 but earlier in my old HP LAPTOP IT WOULD APPEAR AS 55,00,00,000. now i require in 55,00,00,000 format. please help
User
22/08/2018 - 08:04
not possible
Excelchat Expert
22/08/2018 - 08:04
Ok
Excelchat Expert
22/08/2018 - 08:04
I understand
Excelchat Expert
22/08/2018 - 08:04
let me guide you then
User
22/08/2018 - 08:04
okay
Excelchat Expert
22/08/2018 - 08:04
Please allow me a minute to open a file here
User
22/08/2018 - 08:05
okay
Excelchat Expert
22/08/2018 - 08:06
Please right click on the cell for which you want to change the formatting
Excelchat Expert
22/08/2018 - 08:06
Click Format
Excelchat Expert
22/08/2018 - 08:06
Select Custome
Excelchat Expert
22/08/2018 - 08:07
Custom*
User
22/08/2018 - 08:09
okay after that
User
22/08/2018 - 08:09
i want it for all the excel files . as default setting
Excelchat Expert
22/08/2018 - 08:09
Ok
Excelchat Expert
22/08/2018 - 08:10
In that case you have to change the laptop settings
User
22/08/2018 - 08:10
yes pls tell me how to do it
Excelchat Expert
22/08/2018 - 08:10
1. Goto the Control panel and select the “Region and Language” button
2. Select “Additional Settings”
User
22/08/2018 - 08:11
i am using mac
Excelchat Expert
22/08/2018 - 08:11
3. Set digit groupings to the Indian grouping like this:
Excelchat Expert
22/08/2018 - 08:11
[Uploaded an Excel file]
User
22/08/2018 - 08:12
i changed to indian
User
22/08/2018 - 08:12
after that
Excelchat Expert
22/08/2018 - 08:12
you have to select the digit format
User
22/08/2018 - 08:13
where will i find digital format
Excelchat Expert
22/08/2018 - 08:13
I am on Windows, please allow me a minute to look in for the mac
User
22/08/2018 - 08:14
time remaining 9 mins
User
22/08/2018 - 08:14
pls make it asap
Excelchat Expert
22/08/2018 - 08:14
You can extend the session till 60 mins
Excelchat Expert
22/08/2018 - 08:14
that's not a problem
User
22/08/2018 - 08:15
okay sir
Excelchat Expert
22/08/2018 - 08:16
The only way is to format the cell
Excelchat Expert
22/08/2018 - 08:16
we cannot set digit grouping in Mac
Excelchat Expert
22/08/2018 - 08:17
Right click format - in the general
Excelchat Expert
22/08/2018 - 08:17
Custom - General - [>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0
User
22/08/2018 - 08:17
then tell me about microsoft
Excelchat Expert
22/08/2018 - 08:18
On windows - I have already told you. Please refer above chat - I have shared the steps and a image
User
22/08/2018 - 08:18
okau
User
22/08/2018 - 08:19
it worked in mac as well
User
22/08/2018 - 08:19
now how do i make it default .
User
22/08/2018 - 08:20
i mean when ever i open and use excel it should be same
User
22/08/2018 - 08:22
ok
Excelchat Expert
22/08/2018 - 08:23
Yes, it will remain same
Excelchat Expert
22/08/2018 - 08:23
did you use the formula or the formatting formula?
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.