| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
?Formatting cells?
I am running XP Pro+SP2 and Excel 2002.
Why do I get a number when I try to copy the date from the cell above into my working line by hitting Ctrl + '. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
?Formatting cells?
The number is Excel's date storage number.
Format the cell as Date and the number will appear as a date. See Chip Pearson's site for info on how Excel stores dates/times. http://www.cpearson.com/excel/datetime.htm#SerialDates Gord Dibben MS Excel MVP On Sun, 10 Dec 2006 09:16:00 -0800, leonperrins wrote: I am running XP Pro+SP2 and Excel 2002. Why do I get a number when I try to copy the date from the cell above into my working line by hitting Ctrl + '. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
?Formatting cells?
I believe the Ctrl+ ' or the Ctrl + D replicates **ONLY THE VALUE **
Of the Cell ABOVE, it does not include the formatting (of the above source). "leonperrins" wrote in message : I am running XP Pro+SP2 and Excel 2002. Why do I get a number when I try to copy the date from the cell above into my working line by hitting Ctrl + '. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
?Formatting cells?
Right, thanks for that.
Now, I have copied the table into an Access database and the "Excel" numbers have appeared not the dates. Can I converts these numbers to dates in Access or what can I do to transfer the dates themselves? "JMay" wrote: I believe the Ctrl+ ' or the Ctrl + D replicates **ONLY THE VALUE ** Of the Cell ABOVE, it does not include the formatting (of the above source). "leonperrins" wrote in message : I am running XP Pro+SP2 and Excel 2002. Why do I get a number when I try to copy the date from the cell above into my working line by hitting Ctrl + '. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
?Formatting cells?
=TEXT(A1,"dd/mm/yy") or whatever other format you want.
-- David Biddulph "leonperrins" wrote in message ... Right, thanks for that. Now, I have copied the table into an Access database and the "Excel" numbers have appeared not the dates. Can I converts these numbers to dates in Access or what can I do to transfer the dates themselves? "JMay" wrote: I believe the Ctrl+ ' or the Ctrl + D replicates **ONLY THE VALUE ** Of the Cell ABOVE, it does not include the formatting (of the above source). "leonperrins" wrote in message : I am running XP Pro+SP2 and Excel 2002. Why do I get a number when I try to copy the date from the cell above into my working line by hitting Ctrl + '. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
?Formatting cells?
Sorry David,
I do not understand exactly what I should do. "David Biddulph" wrote: =TEXT(A1,"dd/mm/yy") or whatever other format you want. -- David Biddulph "leonperrins" wrote in message ... Right, thanks for that. Now, I have copied the table into an Access database and the "Excel" numbers have appeared not the dates. Can I converts these numbers to dates in Access or what can I do to transfer the dates themselves? "JMay" wrote: I believe the Ctrl+ ' or the Ctrl + D replicates **ONLY THE VALUE ** Of the Cell ABOVE, it does not include the formatting (of the above source). "leonperrins" wrote in message : I am running XP Pro+SP2 and Excel 2002. Why do I get a number when I try to copy the date from the cell above into my working line by hitting Ctrl + '. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
?Formatting cells?
Insert a helper column.. In that column, include the formula I gave, with
the formula in row 1 pointing at cell A1 if your dates are in column A. Copy the formula down your new column. When you are exporting to Access, export the values from your new column, rather than the original dates. -- David Biddulph "leonperrins" wrote in message ... Sorry David, I do not understand exactly what I should do. "David Biddulph" wrote: =TEXT(A1,"dd/mm/yy") or whatever other format you want. -- David Biddulph "leonperrins" wrote in message ... Right, thanks for that. Now, I have copied the table into an Access database and the "Excel" numbers have appeared not the dates. Can I converts these numbers to dates in Access or what can I do to transfer the dates themselves? "JMay" wrote: I believe the Ctrl+ ' or the Ctrl + D replicates **ONLY THE VALUE ** Of the Cell ABOVE, it does not include the formatting (of the above source). "leonperrins" wrote in message : I am running XP Pro+SP2 and Excel 2002. Why do I get a number when I try to copy the date from the cell above into my working line by hitting Ctrl + '. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
?Formatting cells?
Many thanks David.
"David Biddulph" wrote: Insert a helper column.. In that column, include the formula I gave, with the formula in row 1 pointing at cell A1 if your dates are in column A. Copy the formula down your new column. When you are exporting to Access, export the values from your new column, rather than the original dates. -- David Biddulph "leonperrins" wrote in message ... Sorry David, I do not understand exactly what I should do. "David Biddulph" wrote: =TEXT(A1,"dd/mm/yy") or whatever other format you want. -- David Biddulph "leonperrins" wrote in message ... Right, thanks for that. Now, I have copied the table into an Access database and the "Excel" numbers have appeared not the dates. Can I converts these numbers to dates in Access or what can I do to transfer the dates themselves? "JMay" wrote: I believe the Ctrl+ ' or the Ctrl + D replicates **ONLY THE VALUE ** Of the Cell ABOVE, it does not include the formatting (of the above source). "leonperrins" wrote in message : I am running XP Pro+SP2 and Excel 2002. Why do I get a number when I try to copy the date from the cell above into my working line by hitting Ctrl + '. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
| Merge Cells | Excel Discussion (Misc queries) | |||
| Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
