In a blank cell somewhere on your worksheet enter the number 100. Then copy
the cell you've just entered, select the cell that has the value 5394 and
click EDIT in the menu and select PASTE SPECIAL. In the dialog box select
DIVIDE from the OPERATION panel about mid dialog box and click OK. This will
divide your value and give the desired result.
Now, if you want to enter data without having to enter a decimal point you
can do the following:
Click TOOLS in the menu
Select OPTIONS
Click the EDIT tab
Click the FIXED DECIMALS check box
If necessary, set the number of decimal positions to 2
Hope this helps.

Signature
Kevin Backmann
--
Kevin Backmann
> Ok, so here's what I'm trying to do, the field has a number 5394, I want it
> to format as 53.94. I've tried ##.## but the answer is 5394.00. Too rich
> for my blood. I'm new at this.... really!
Jerene - 27 May 2008 19:52 GMT
SCATHINGLY Brilliant..... Thank you so much, oh the time you've saved me!
> In a blank cell somewhere on your worksheet enter the number 100. Then copy
> the cell you've just entered, select the cell that has the value 5394 and
[quoted text clipped - 16 lines]
> > to format as 53.94. I've tried ##.## but the answer is 5394.00. Too rich
> > for my blood. I'm new at this.... really!
go to tools | options | Edit tab | check fixed decmical option |
places type 2
click ok
once the above steps done & whenever u type the number in excel sheet
eg., 1234 it convert into 12.34.
> Ok, so here's what I'm trying to do, the field has a number 5394, I want it
> to format as 53.94. I've tried ##.## but the answer is 5394.00. Too rich
> for my blood. I'm new at this.... really!