| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
I need Excel to make "1" into "001"
Yep. The value is the sort order, not the display.
************ Anne Troy www.OfficeArticles.com "Terry" wrote in message ... I just change cell format to text it works, however when I sort them latter, numerical data and text data they sory separately. Will the way you guys provide can deal the problem of latter sorting? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, when column A and B have same name make column C add up in mail merge | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel formula to make AAA-BBB equal to/consistent with BBB-AAA | Excel Worksheet Functions | |||
| How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
| Make copy from any document into Excel a right click with a drop . | Excel Worksheet Functions | |||
Hybrid Mode
