How do I covert number format?

  • Thread starter Thread starter silentbobafett
  • Start date Start date
S

silentbobafett

Hi,
I have a sheet with a bunch of numbers that look like this.

6.22
8.99
11.22
0.81

i need to turn those numbers into a 5 digit number, without the
decimal.

00622
00899
01122
00081

Does anyone know an easy way to do this?
 
1. Put 100 into an open cell.
2. Copy the cell.
3. Select your numbers.
4. Go to Edit > Paste Special > Multiply
5. Press <Ctrl><1>.
6. Go to Number Tab.
7. Select Custom
8. On the right insert 00000.

HTH
Jason
Atlanta, GA
 
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

How do I Return a Value Using Multiple Criteria? 1
How do I prevent the cell from changing the number I enter? 2
Convert a number to Hours, Minutes, etc. 3
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
Importing Long Numbers as Text cells 1
How do I format complex numbers ? 4
Need a formula for a descimal integer into a whole number 1
Numbers will not format properly 2

Back
Top