| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format a column wihtout using "Format-Cells-Number-category-etc"
I download data from JD Edwards into excel and do a vlookup with another
excel spreadsheet. Although I change the format of the column (I am doing a vlookup) to match the column of the other spreadsheet (format-cell-text, or whatever) it still does not match. I also tried Data-Text to column-next-next-finish which sometime works. Although they are both set to TEXT, it cant find it. Is there a better way to match the format of columns I am comparing to text (or number) or whatever, as long as they become perfectly the same. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
