| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
confused about date format
I used vlookup to show date in another sheet. in the original sheet it the
date is blank, but in the other sheet as a result of the vlookup, the date is "00-Jan_00" for the blank date in the original sheet. My question is how can I show it as original sheet showing it blank (not 00-Jan-00) Many thanks for any idea Frank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| confused,please help | Excel Discussion (Misc queries) | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
| How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Threaded Mode
