Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing patterns without removing gridlines | Excel Discussion (Misc queries) | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Removing % sign, but keeping the formatting | Excel Discussion (Misc queries) | |||
Removing formatting | Excel Discussion (Misc queries) | |||
Removing the +4 from zip+4 | Excel Discussion (Misc queries) |