ExcelBanter - data entry currency as cents if entering 2 numbers

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - data entry currency as cents if entering 2 numbers (https://www.excelbanter.com/excel-discussion-misc-queries/175321-re-data-entry-currency-cents-if-entering-2-numbers.html)

Jim Thomlinson

data entry currency as cents if entering 2 numbers

Tools - Options Edit - Check fixed decimal places (ensure the number is 2)
--
HTH...

Jim Thomlinson

"Nonie" wrote:

Hi there,

I want excel to return "$.59" if I type in "59" and "$1.59" if I type in
"159"

Is there a way to do this?

Thanks!

All times are GMT +1. The time now is 10:47 PM.