Question description:
This user has given permission to use the problem statement for this
blog.
hi! can you tell me what's the custom number format if i want to change 162,5 to 162,500? it's a money value so the other (ex. if i write 162 it will change to 162,000) was like this ##,###",000"
Solved by M. U. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/08/2018 - 07:05
Hi
Excelchat Expert
13/08/2018 - 07:05
Welcome to Got IT Pro.
User
13/08/2018 - 07:05
hi!
Excelchat Expert
13/08/2018 - 07:06
I have referred the requirement. You want to change the format of the cell?
User
13/08/2018 - 07:06
yes
Excelchat Expert
13/08/2018 - 07:06
After 162, is it comma or decimal?
User
13/08/2018 - 07:07
i have other number formatted as for example if i write down 162 it will be 162,000
User
13/08/2018 - 07:07
i wanted if i write down 162,5 (with either comma or decimal) it will change to 162,500
Excelchat Expert
13/08/2018 - 07:07
Please refer the B1 cell.
User
13/08/2018 - 07:07
without changing the other format
Excelchat Expert
13/08/2018 - 07:08
Without changing the format?
User
13/08/2018 - 07:08
yep
Excelchat Expert
13/08/2018 - 07:08
You want it to be with formula?
User
13/08/2018 - 07:08
for example i had this
User
13/08/2018 - 07:09
with this custom format
User
13/08/2018 - 07:09
##,###",000"
User
13/08/2018 - 07:09
so if i continue down
User
13/08/2018 - 07:09
and i write 162,5
User
13/08/2018 - 07:09
it will be 162,500
Excelchat Expert
13/08/2018 - 07:10
Please check in the formula in E1 cell.
User
13/08/2018 - 07:11
how to write the custom numbering in the format instead?
Excelchat Expert
13/08/2018 - 07:11
=TEXT(D1,"#,###.000")
Excelchat Expert
13/08/2018 - 07:12
You can use text function, if you want to usethe formula. Else, you have to change cell formatting using custom format.
User
13/08/2018 - 07:12
i mean in the format>number>more format>custom number format
Excelchat Expert
13/08/2018 - 07:12
Yes. You can enter the format as shown in double quotes
Excelchat Expert
13/08/2018 - 07:13
I did it in B1 cell.
Excelchat Expert
13/08/2018 - 07:13
But, you are looking for formula?
User
13/08/2018 - 07:13
ohhh got it
Excelchat Expert
13/08/2018 - 07:13
B1: Using custom formmat
Excelchat Expert
13/08/2018 - 07:13
Great to hear.
User
13/08/2018 - 07:13
i see i see
User
13/08/2018 - 07:13
thank you very much!
Excelchat Expert
13/08/2018 - 07:14
Please do visit Got It Pro. We have 24 * 7 problem solving facility. You can visit any time.
User
13/08/2018 - 07:14
you're great
Excelchat Expert
13/08/2018 - 07:14
Have wonderful day ahead. Please end the session and leave valuable feedback.
User
13/08/2018 - 07:14
awesome will do
User
13/08/2018 - 07:14
thankyou!
Excelchat Expert
13/08/2018 - 07:14
Thank you.
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.