| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert a decimal into a whole number. 100 to 1.00
I have a larger amount of imported data that is in whole number form and I
need to insert a decimal. Change 100 to 1.00 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert a decimal into a whole number. 100 to 1.00
put 100 in an empty cell, copy it, select the numbers and do editpaste
special and select divide, format as number with 2 decimals -- Regards, Peo Sjoblom "Runner74" wrote in message ... I have a larger amount of imported data that is in whole number form and I need to insert a decimal. Change 100 to 1.00 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert a decimal into a whole number. 100 to 1.00
put 100 in an empty cell
edit|copy (that cell) select the range to fix edit|Paste special|check divide Clean up that cell with 100 in it and format the range you just fixed to show the number of decimals you like. Runner74 wrote: I have a larger amount of imported data that is in whole number form and I need to insert a decimal. Change 100 to 1.00 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a decimal into a fixed number? | Excel Discussion (Misc queries) | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| How do I insert 2 decimal places to a number in cell? | Excel Worksheet Functions | |||
| I need help insert a decimal other then directly to the right of t | Excel Discussion (Misc queries) | |||
| How to convert a decimal number to a non-decimal number? | Excel Worksheet Functions | |||
Linear Mode
