Custom Format Numbers to $$
 

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!

Custom Format Numbers to $$
 

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.



--
Kevin Backmann
--
Kevin Backmann


"Jerene" wrote:

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!

Custom Format Numbers to $$
 

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.

On May 27, 11:26*pm, Jerene wrote:
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!

Custom Format Numbers to $$
 

SCATHINGLY Brilliant..... Thank you so much, oh the time you've saved me!

"Kevin B" wrote:

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.



--
Kevin Backmann
--
Kevin Backmann


"Jerene" wrote:

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!