Removing formatting

[Guest]

Hi,

I am trying to do some work on some cells that contain dates. One column
contains the day of the month, the next the month and the next the year.
However, when I click on the month or year, (e.g. Jul) it shows as
01/07/1900. When I try to concatenate all three I get a weird figure as an
output rather than a full date. If I tray and change the individual format
of a cell it loses it’s value (i.e. Apr turns to 92).

What I have been doing is copying the table, pasting into MS Word and
copying & parting back into excel to keep the values but lose the weird
formatting. However this takes some time and I was wondering if there is a
quicker way??

cheers,

 

[Dave Peterson]

=text(a1,"mm/dd/yyyy")&" is a date--"&text(a2,"mm/dd/yyyy")&" is another").