Displaying Numbers with comma

t111kav

New Member
Joined
Jul 22, 2014
Messages
21
Hi guys,

I am trying to format a column to display numbers as 16,00 or 1654,00 but i am unable to format the cells appropriately and can only get a result of 16.00 and 1,650.00. I need any future number entered in the column/cell to use this format so using a =TEXT(cell,"0,00") formula or equivalent isnt suitable.

Any help would be much appreciated,

Thanks in advance

T111KAV
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
From PGC01 - only found this after searching again. apologies

Hi Drew


In excel 2010 you can manage the separators inside Excel.

To change the separators in all the number values

Options->Advanced, in the first group "Editing options"
- Uncheck Use system separators.
- In the Decimal sparator box write a comma
- In the Thousands separator box write a dot
- Press OK

Go back to the worksheet and check that all the number are now displayed with the new separators.
Save the worksheet as csv and confirm opening it for ex., with the notepad.

P. S. make the test in a copy of the workbook



Hi guys,

I am trying to format a column to display numbers as 16,00 or 1654,00 but i am unable to format the cells appropriately and can only get a result of 16.00 and 1,650.00. I need any future number entered in the column/cell to use this format so using a =TEXT(cell,"0,00") formula or equivalent isnt suitable.

Any help would be much appreciated,

Thanks in advance

T111KAV
 
Upvote 0
Assuming the ",00" element is not meant to signify decimals, you could use a Custom format of ###","00
 
Upvote 0
Check your langauge settings. Its on Control panel->Local & Languages (I'm not sure if its in English)->Format tab, bottom right corner there is More settings/Advanced button.
After you change the decimal point try this custom cell format: #0.00 (or #0,00)
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,949
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top