Prev: taking conditions from one spreadsheet to another
Next: finding and replacing
From: The Demon on 3 Jul 2008 06:33
Hi Everyone, hoping someone can help me with this.

I have a massive sheet full of numbers, however, they should have been
entered as values less than 1.

eg - Cell has an entry of "5" and it should be "0.05"

Is there anyway I can move the decimal place in the cells I want to?

Thanks for your help,

The Demon, Sunny Scotland
From: Pete_UK on 3 Jul 2008 06:46
Enter 100 in a blank cell somewhere. Select that cell and click on
<copy>. Then move your cursor and highlight the cells that you want to
change. Click on Edit | Paste Special | Values (check) | Divide
(check) | OK then <Esc>. All the values will have been divided by 100
in the one operation. You can delete the 100 from the original cell.

Hope this helps.

Pete

On Jul 3, 11:33 am, The Demon <TheDe...(a)discussions.microsoft.com>
wrote:
> Hi Everyone, hoping someone can help me with this.
>
> I have a massive sheet full of numbers, however, they should have been
> entered as values less than 1.
>
> eg - Cell has an entry of "5" and it should be "0.05"
>
> Is there anyway I can move the decimal place in the cells I want to?
>
> Thanks for your help,
>
> The Demon, Sunny Scotland

 | 
Pages: 1
Prev: taking conditions from one spreadsheet to another
Next: finding and replacing