Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date formatting
I have an excel sheet which has a date in yyyy/mm/dd format saved on the
internal network. other users who open the file do not see this date as the same format as the saved file. could anyone provide as to why this is happening and what can be done to correct it. thanks vandy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date formatting
Sounds like you have not specifically formatted the cell as yyyy/mm/dd.
When you don't specifically format a date cell, Excel will look at your Windows default setting and use that, so you will see a date as yyyy/mm/dd and someone else will see it as mm/dd/yy depending on their windows setting. To fix this issue, highlight the cell, select FORMAT CELLS NUMBER CUSTOM TYPE yyyy/mm/dd OK -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "vandy" wrote: I have an excel sheet which has a date in yyyy/mm/dd format saved on the internal network. other users who open the file do not see this date as the same format as the saved file. could anyone provide as to why this is happening and what can be done to correct it. thanks vandy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Date and Formatting | Excel Worksheet Functions | |||
Date Formatting | Excel Discussion (Misc queries) | |||
Date formatting | Excel Discussion (Misc queries) | |||
Date Formatting | Excel Discussion (Misc queries) |