Need help in formating numbers into amount
Hi friends , i am new to ms excel
when i use worksheet with a column that has number 320 and When I go to format it into currency, etc. I select the decimal to move 2 places. Although it keeps giving me $48,600.00. I don't want that. What I need is to make my number 32000 $320.00I want it to put $486.00.
thanks in advance for any help.
Re: Need help in formating numbers into amount
Hi , Here is a solution of your problem
Type 320 in a blank cell and copy that cell. Now select the range of cells to be converted and after that go to edit menu click on paste special in that check Divide and Values .click ok.
tell me if it works.
|Tags: amount, formating, numbers|
|Thread Tools||Search this Thread|
|Similar Threads for: "Need help in formating numbers into amount"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|How to change negative numbers to positive numbers in Excel||Shaina Na||Microsoft Project||3||08-01-2012 05:35 PM|
|Need C program code to count numbers of negative & positive numbers||Sarfaraj Khan||Software Development||5||16-01-2010 02:00 PM|
|SQL Query for Searching Missing Numbers from Sequence of Numbers||Bhagwandas||Software Development||3||18-02-2009 01:47 PM|
|How to Use Chapter Numbers with Page Numbers In Ms Word||Braze||Windows Software||3||27-12-2008 07:01 PM|
|HHD Formating Problem||kex||Hardware Peripherals||5||05-11-2008 07:34 PM|