numbers

T

Tamara

we received a spreadsheet with numbers, i.e, 12300 34500 - We need to move
the decimal point over to the left twice to produce 123.00. I'm only coming
up with 1,230.00 I used a DOLLAR formula to produce the 123.00, but wasn't
able to paste it to the other cells without repeating the same number.
Please help. There are many entries!
Thanks!
 
B

Bill Ridgeway

You need a helper column with the formula =A1/100

Regards.

Bill Ridgeway
Computer Solutions
 
G

Gord Dibben

Tamara

Without formulas to clean up later..............

Enter 100 in an unused cell.

Copy that cell. Select the range of numbers and Edit>Paste
Special>Divide>OK>Esc.

Clear the cell with the 100.


Gord Dibben MS Excel MVP
 

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

Find/Replace Numbers stored as Text drops zeros 1
How do I extract the decimal places from a number in excel? 3
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
count array for top three entries and return their number 4
Number to text 2
Replacing part of a (too) long formula 5
Copied Values Rounded to 1,000s 3
add decimal to beginning of number 1

Top