ExcelBanter - Cell entry

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

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

- - Cell entry (https://www.excelbanter.com/excel-discussion-misc-queries/42518-cell-entry.html)

vnsbudhe

Cell entry

Whe I enter 100 in a cell it displays ".01" what is wrong in setting. Pl
help

--
vnsbudhe
------------------------------------------------------------------------
vnsbudhe's Profile: http://www.excelforum.com/member.php...o&userid=25498
View this thread: http://www.excelforum.com/showthread...hreadid=399544

David Hepner

Check

ToolsOptionsEditFixed Decimal Place to see if the check box is checked.

If so, uncheck.

"vnsbudhe" wrote:

Whe I enter 100 in a cell it displays ".01" what is wrong in setting. Pl
help

--
vnsbudhe
------------------------------------------------------------------------
vnsbudhe's Profile: http://www.excelforum.com/member.php...o&userid=25498
View this thread: http://www.excelforum.com/showthread...hreadid=399544

All times are GMT +1. The time now is 01:08 PM.