Prev: Help with Ribbons! AAARGH!
Next: Absolute reference (F4 Key) not working
From: desilkman on 17 Mar 2010 14:32
I have hundreds of data in millimetre and would like some help in converting
them to metres without having to place decimal points three places from the
right on each cell.

Thanks,

Desilkman
--
Learn To Listen and Listen To Learn
From: Fred Smith on 17 Mar 2010 14:44
You have many options. It depends on what else you don't want to do. Here's
one option:
* Put 1000 in an empty cell.
* Copy that cell
* Highlight the data you want to change
* Right-click, choose Paste Special...> Divide>Ok

Regards,
Fred

"desilkman" <desilkman(a)discussions.microsoft.com> wrote in message
news:1D3EE4AB-6159-4836-8DD4-F7147E1CC9A6(a)microsoft.com...
>I have hundreds of data in millimetre and would like some help in
>converting
> them to metres without having to place decimal points three places from
> the
> right on each cell.
>
> Thanks,
>
> Desilkman
> --
> Learn To Listen and Listen To Learn

From: Mike H on 17 Mar 2010 15:07
Hi,

Put the number 1000 in an empty cell and copy it.

Select your data in mm and right click|Paste special|Select divide - OK

and your done
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"desilkman" wrote:

> I have hundreds of data in millimetre and would like some help in converting
> them to metres without having to place decimal points three places from the
> right on each cell.
>
> Thanks,
>
> Desilkman
> --
> Learn To Listen and Listen To Learn
 | 
Pages: 1
Prev: Help with Ribbons! AAARGH!
Next: Absolute reference (F4 Key) not working