Hello All,
I have an Excel 2000 spreadsheet where various three digit cost codes are used that have zeros in front of the numbers. When 001 is entered it is interpreted as a number and is displayed as 1, but users have formatted the cells as text to get it to display 001. Values entered as say 203 are OK.
I have tried using a custom number format for the input cell for the VLOOKUP but get an error. Is it possible to to have an input cell that is either text of a number??
I suppose it will be easier to convert and the codes to numbers using Edit>Copy then Edit>Paste Special and select the Add option and then apply a custom number format to show the zeros.
Thanks in advance
I have an Excel 2000 spreadsheet where various three digit cost codes are used that have zeros in front of the numbers. When 001 is entered it is interpreted as a number and is displayed as 1, but users have formatted the cells as text to get it to display 001. Values entered as say 203 are OK.
I have tried using a custom number format for the input cell for the VLOOKUP but get an error. Is it possible to to have an input cell that is either text of a number??
I suppose it will be easier to convert and the codes to numbers using Edit>Copy then Edit>Paste Special and select the Add option and then apply a custom number format to show the zeros.
Thanks in advance