| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transposing an array converts dates into numbers
Hi,
Sorry if this has already been answered but I couldn't find it among the posts. I have some data that I am transposing using an array formula. One of the columns contains dates. When I transpose rows into columns, this date appears as a number. Is there anyway of making the array formula show this as dates? Thanks in advance. Mehmet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using which function to calculatiing 2 set of numbers of days from 3 dates | Excel Discussion (Misc queries) | |||
| Wekk numbers and dates | Excel Worksheet Functions | |||
| converting dates into numbers | Excel Discussion (Misc queries) | |||
| Combo Box Showing numbers not dates | Excel Discussion (Misc queries) | |||
| micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions | |||
Threaded Mode
