ExcelBanter - wrong number, no currency format

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

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

- - wrong number, no currency format (https://www.excelbanter.com/excel-discussion-misc-queries/210471-wrong-number-no-currency-format.html)

dberger16

wrong number, no currency format

each time i enter a number in a worksheet such as 5, it shows up as .05.
also, i cannot get my worksheet to format the cells in currency without
pressing the $ icon. thank you.
--
DaveB

vezerid

wrong number, no currency format

Tools Options Edit tab

Uncheck the Fixed Decimal Places checkbox.

HTH
Kostis Vezerides

On Nov 16, 3:25*pm, dberger16 wrote:
each time i enter a number in a worksheet such as 5, it shows up as .05. *
also, i cannot get my worksheet to format the cells in currency without
pressing the $ icon. * thank you.
--
DaveB

All times are GMT +1. The time now is 03:41 PM.