Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 14-11-2008
Member
 
Join Date: Aug 2006
Posts: 181
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.
Reply With Quote
  #2  
Old 14-11-2008
Member
 
Join Date: Feb 2008
Posts: 1,848
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 03:00 AM.