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

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/

Thanks

--
Message posted from http://www.ExcelForum.com