Excel Issue for decimal Point

[Bassus]

Hi,
I am having an issue in Excel.I want to have Decimal Point inserting in my sheet without putting a point. I know that can be done, but i have forget it .Can anyone tell me the solution for this.I would be very Great full to you.

[Glenny]

Sure you can do this by following the steps:-

1. Click on Tools
2. Than Options
3. Goto Edit and Select Fixed Decimal Places.

[Aarpitt]

But this would be for only Specific Column.

You can use the following this for putting a decimal point in whole sheet.

Create a column for data entry (Col. A, for example). In column B, enter =A1/100 with a fixed 2-decimal format (or A1/1000 for 3 decimals, etc...)

User enters 1050 in A1, gets 10.50 in B1 if fixed for 2 decimal.

[Bassus]

Thanks a lot for your help, it worked out for me.