Number formatting

Donald · #1 10-26-2007, 10:21 PM

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

starguy · #2 10-27-2007, 02:25 AM

Quote:

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.

starguy · #3 10-29-2007, 12:53 AM

Quote:

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