Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Urgent Problem with Number Column
I am new to EXCEL 2003, and I have this problem, so if you can give me an
answer, please explain in easy English. I have a column with consecutive numbers that I use to sort with (1 to 8000). However, for some reason some of the numbers have ended up with decimal points, others are facing left, and still others are aligned to the right. I want to format the entire column so the numbers are just that, numbers, so I can sort and resort this column. How do I do this? |
#2
|
|||
|
|||
Select the column, Format/Cells/Number tag, choose number!
Stefi "Rebecca" wrote: I am new to EXCEL 2003, and I have this problem, so if you can give me an answer, please explain in easy English. I have a column with consecutive numbers that I use to sort with (1 to 8000). However, for some reason some of the numbers have ended up with decimal points, others are facing left, and still others are aligned to the right. I want to format the entire column so the numbers are just that, numbers, so I can sort and resort this column. How do I do this? |
#3
|
|||
|
|||
Click in an empty cell. Copy.
Select the entire column of interest, then Edit | Paste Special... | Operation section| select Add. Click OK. This will force XL to convert all numbers that it considers as text into numbers that it considers as numbers. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am new to EXCEL 2003, and I have this problem, so if you can give me an answer, please explain in easy English. I have a column with consecutive numbers that I use to sort with (1 to 8000). However, for some reason some of the numbers have ended up with decimal points, others are facing left, and still others are aligned to the right. I want to format the entire column so the numbers are just that, numbers, so I can sort and resort this column. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Program Column B to record numerical range based on number in colm | Excel Discussion (Misc queries) | |||
NUMBER PROBLEM | New Users to Excel | |||
chart label reference based on the column number | Charts and Charting in Excel | |||
Automatic Number Creation Problem? | Excel Worksheet Functions | |||
Circular Problem needs Macro | Excel Discussion (Misc queries) |