Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Custom Format Numbers to $$

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jerene - 27 May 2008 19:26 GMT
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!
Kevin B - 27 May 2008 19:37 GMT
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!
muddan madhu - 27 May 2008 19:38 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.