| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by Hebrew Date
Does anyone know if (and how) Excel's sort by date function can be used to
sort by Hebrew date rather than English Date? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort by Hebrew Date
Excel can handle the year, but the months and days do not map directly. If
you format the dates as integers in the form yyyymmdd, always using 2 digits for the month and day, the standard numerical sort might work. -- Gary's Student "Desperate Dan" wrote: Does anyone know if (and how) Excel's sort by date function can be used to sort by Hebrew date rather than English Date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another Date issue. | Excel Worksheet Functions | |||
| How do you sort a date range by month? | Excel Discussion (Misc queries) | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Excel 2003 "File Open": how keep folders at top with sort by Date. | Excel Discussion (Misc queries) | |||
Linear Mode
