Removing formatting
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 its 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, |
Removing formatting
=text(a1,"mm/dd/yyyy")&" is a date--"&text(a2,"mm/dd/yyyy")&" is another").
kippers wrote: 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 its 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 |
All times are GMT +1. The time now is 08:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com