U
uv_katastrophe
Excel 2002 on MS 2000
I have an issue that I cannot seem to resolve when concatenating
several fields which includes one with a date format. Certain dates
convert to a number, i.e. a date that is formatted to 1/14/2005 will
convert to 38366 when I concatenate it with other fields, whereas every
other row will keep the same date format. This has been happening to
me for months now, with different spreadsheets.
Has anybody had a similar problem?
I have an issue that I cannot seem to resolve when concatenating
several fields which includes one with a date format. Certain dates
convert to a number, i.e. a date that is formatted to 1/14/2005 will
convert to 38366 when I concatenate it with other fields, whereas every
other row will keep the same date format. This has been happening to
me for months now, with different spreadsheets.
Has anybody had a similar problem?