Add Decimal to Cells 2 places to left of number.

D

dlkingace

I exported a table from another program that includes fees. Onl
problem, the cells are now whole numbers. I need to add a decimal
places to the left of the last number. For example, I need to turn:

227500
490
170000

into:

2275.00
4.90
1700.00

Is there a simple way of going about this?
Thanks in advance
 
L

Lady Layla

In a blank cell type in .1
Select Edit Copy
Select the numbers you need to change
Select Edit Paste Special Multiply Ok


:
: I exported a table from another program that includes fees. Only
: problem, the cells are now whole numbers. I need to add a decimal 2
: places to the left of the last number. For example, I need to turn:
:
: 227500
: 490
: 170000
:
: into:
:
: 2275.00
: 4.90
: 1700.00
:
: Is there a simple way of going about this?
: Thanks in advance!
:
:
: --
: dlkingace
: ------------------------------------------------------------------------
: dlkingace's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=16487
: View this thread: http://www.excelforum.com/showthread.php?threadid=278337
:
 
F

flashing frank

dirty but quick:

use a free colummn and:

=A1/100 (copy it down)
so 227500 becomes 2275

format > cell > number (and check the options there, for the .00 part)


here you g
 
Top