Thread: How do I create a custom 'price' column?
View Single Post
Old 09-16-2020, 02:35 AM   #2
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Unless you are storing the price as cents, you probably don't want to use integers. You probably want to use "Floating point numbers". That will let you enter the number as dollars with cents. And, to answer the unasked question, you can set the "Format as numbers" to:

Code:
${:,.2f}
That will show it with a leading $ sign and always with two decimals.
davidfor is offline   Reply With Quote