| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column of data
Info only............
If Excel sees the numbers as Text, simply re-formatting will do absolutely nothing. Gord Dibben MS Excel MVP On Fri, 12 Feb 2010 10:27:01 -0800, trip_to_tokyo wrote: Try this:- Click the column header letter (eg A) to highlight the column then, in EXCEL 2007, right hand click / Format Cells / Number tab / select Number on the left hand side / OK. If my comments have helped please hit Yes. Thanks. "PTS" wrote: I have a column of numbers that have been copied from another spread sheet and each box has a green triangle in the upper right corner. The column will not sort properly as some of the boxes do not have the triangles in the upper right corner. I can get ride of these by going to the box and double clicking but I have approximately 4000 to do . Is there a way to do this with one command ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort data in column B to align with data in column A? | New Users to Excel | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| counting data in one column and match with data in another column | Excel Discussion (Misc queries) | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
| Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions | |||
Hybrid Mode
