| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I write 3/5 in a cell and have it look like 03-May back?
Have tried to write in 3/5 and have it look like 03-May back, but excel
always comes back with 05-March! Have tried to format cells with both dates and specials and also tried the "text to columns" but nothing works. Anyone who can solve this problem? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I write an infinite amount in a cell with expanding the cell? | Excel Discussion (Misc queries) | |||
| write value to another cell in excel | Excel Worksheet Functions | |||
| How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
| OLAP write back via formulas (functions), not read only pivot tab | Excel Worksheet Functions | |||
Threaded Mode
