Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automaitcally changed text when copying
I created a master sheet. when copying dates to another worksheet in this
workbook it is changing the date to a number which is meaningless. i.e. 9/24/08 to 23498. I changed the formating to text and it didn't help. It didn't work in date format either. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
automaitcally changed text when copying
The number is not meaningless. It tells how many days passed since 1/1/1900.
9/24/08 is represented by 39715 internally. You have to format with date instead of text. And then it'll display it the way you want it to. "sae" wrote: I created a master sheet. when copying dates to another worksheet in this workbook it is changing the date to a number which is meaningless. i.e. 9/24/08 to 23498. I changed the formating to text and it didn't help. It didn't work in date format either. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying charts - font size changed | Charts and Charting in Excel | |||
automaitcally update external defined names? | Excel Discussion (Misc queries) | |||
Copying changed pivot report headings | Excel Discussion (Misc queries) | |||
My text was changed to red... | New Users to Excel | |||
Text not fully displayed when text direction changed | Excel Discussion (Misc queries) |