Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SI units Conversion
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SI units Conversion
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... DivideOk Regards, Fred "desilkman" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SI units Conversion
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Units Produced / (finish time minus start time)=Units Per Hr | Excel Worksheet Functions | |||
Units Conversion in Charts Source data | Excel Discussion (Misc queries) | |||
Units of measure | Excel Worksheet Functions | |||
convert units | Excel Discussion (Misc queries) | |||
units | Excel Discussion (Misc queries) |