| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
losing date format when referencing date cell on another sheet
I should have added that you can also use the number format and simply create
your own custom format and that way the cell remains as a date instead of text. Use this custom format (dd/mm/yyyy) Your formula would then be =Sheet1!B15 -- Regards, OssieMac |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Losing date format when saving .csv files | Excel Discussion (Misc queries) | |||
| How can I get date of file creation to XLS cell in date format? | Excel Worksheet Functions | |||
| Retaining date formatting in referencing cell | Excel Discussion (Misc queries) | |||
| Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
| How do I change date format without losing data? | New Users to Excel | |||
Threaded Mode
