ExcelBanter - how do I format decimals

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - how do I format decimals (https://www.excelbanter.com/excel-programming/308850-re-how-do-i-format-decimals.html)

Andoni[_34_]

how do I format decimals

go to format/cell/number/customice
and put:

#","##0,00
1375850 you will get 13,758,50

otherwise use this one "actually better!

#.##0,00
you will get
13.758,5

--
Message posted from http://www.ExcelForum.com

All times are GMT +1. The time now is 04:27 AM.