Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please
I have a column of numbers much like the following sample:
11.07 11 07 16.43 16.43 12 78 15 17 11 07 15 07 14 28 9 39 15 34 8 89 14 28 Notice how some have decimal points and some do not. Some are 3 lon and some are 4 long. The digits are never over 4 long, how can I ge the decimal in there were a space is located -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please
1. Select all of the cells
2. Use Ctrl+H to bring up the Search & Replace dialogue box 3. In the top box press the space bar once 4. In the Replace box type a period (decimal point) 5. Select Replace all :) --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Please
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|