Thread: Possible:Number formatting

Originally Posted by Donald

When I export files to excell, Is it possible to remove that green triangle so I can have the cell formatted for a number?

Select the range of data, right click, Format cells..., select Number form category list and hit ok.

That did not work, it seems that there is a one space then the number, how can I remove this space at one time on a cloumn of numbers?

Thanks

Select the range of cells.

Press Ctrl+H
Find what: press space bar once
Replace with: leave it blank
Hit Replace All