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/