| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date format clarification
I believe the "[$-409]" will switch formats if opened on another PC, if
needed. -- Regards Dave Hawley www.ozgrid.com "Blue Max" wrote in message ... When a user selects the 14-Mar-01 standard date format in Excel 2007, then selects the custom format option, this is the standard format that displays: [$-409]d-mmm-yy;@ What is the significance of the prefix "[$-409]" included with this standard format? Why is that prefix even necessary and is it necessary to include the prefix for all custom date formats we create? Thank you for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| Clarification | Excel Discussion (Misc queries) | |||
| DATE function clarification | Excel Worksheet Functions | |||
| Sumproduct Date clarification | Excel Worksheet Functions | |||
| If function clarification | Excel Worksheet Functions | |||
Threaded Mode
