| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
date format in excel 2002 on win 7
on this forum a helpful expert posted
With a value in A1: =A1&IF(AND(A110,A1<20),"th",CHOOSE(MOD(A1,10)+1," th","st","nd","rd","th","th","th","th","th","th" )) with my version i get 10 th not 10th same with 20. so i changed the formula 10 and 20 to 9 and 19. worked for 10th but not 20 and 30. what do i do? and can i change a date say january 20 2006 and using this formula to get January 20th 2006, all in one cell? at the moment i am using a separate column for, month,day and year. i need to copy paste them into a text file. thanks all Last edited by anon125 : May 4th 20 at 02:04 AM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: How to make the date format uniform ? | Excel Discussion (Misc queries) | |||
| using a date format not in Excel 2002 | Excel Discussion (Misc queries) | |||
| Date format in Excel 2002 | Excel Discussion (Misc queries) | |||
| Excel 2002 - Date format keeps changing | Excel Discussion (Misc queries) | |||
| Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
Threaded Mode
