Excel 2003 - converting 51322 to 513.22
Excellent direction! Thanks so much! I love this stuff!
"Niek Otten" wrote:
Format an empty cell as Number. Enter the number 100 in it. EditCopy.
Select your cells to be divided. Paste Special, check Divide.
Always try new things on a copy of your workbook first.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"tuzdazchild" wrote in message ...
| need assistance in converting three columns of numbers (all 5digit) to insert
| the decimal 2 places in. I am only able to add decimal at end, which makes
| it 51322.00
|
| only other way is to manually change each cell, and that's about 3000 cells!
|
| please advise, and thanks, in advance for prompt reply.
|