Coverting numbers to decimal

  • Thread starter Thread starter Newbee
  • Start date Start date
N

Newbee

How do I convert 5000000 on a spread sheet to 5.0 without having to divide by
1000000.
 
Right click the cell
Format Cell
Number Tab
Custom -> Add the following
0.0,,
 
That does not "convert" the value.

Just displays the same value differently.

Hope you're not relying on 5.0 when adding up your phone bill.


Gord Dibben MS Excel MVP
 
Hi,

As Gord said this does not convert the 5000000 to 5 it just changes the
display. If you want to convert a lot of number in the same way:

1 Enter 1000000 in an empty cell
2. Copy the cell
3. Highlight all the cells you want to convert and choose Edit, Paste
Special, Divide
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates coverted to formulas 3
Need Help Creating a Macro to Multiply Cells by a Constant Number 5
percentage question 6
Convert a number to Hours, Minutes, etc. 3
Where and how can I adjust a curreny number 1
Does anyone know how to create a pace calculator (min/mile) in Exc 10
Your entry cannot be used. An integer or decimal number may be req 3
Custom Format with multiple conditonals 1

Back
Top