| 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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I write 3/5 in a cell and have it look like 03-May back?
You may need to look at your date format settings in Windows/ Regional
Options (accessed through Control Panel, not Excel). Then try re-entering the data. Once the date is stored (as a number), reformatting the cell in Excel will not change the underlying date stored. -- David Biddulph "Janneman" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I write 3/5 in a cell and have it look like 03-May bac
Thank you David!
This worked just fine! "David Biddulph" wrote: You may need to look at your date format settings in Windows/ Regional Options (accessed through Control Panel, not Excel). Then try re-entering the data. Once the date is stored (as a number), reformatting the cell in Excel will not change the underlying date stored. -- David Biddulph "Janneman" wrote in message ... 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I write 3/5 in a cell and have it look like 03-May bac
Glad it helped.
-- David Biddulph "Janneman" wrote in message ... Thank you David! This worked just fine! "David Biddulph" wrote: You may need to look at your date format settings in Windows/ Regional Options (accessed through Control Panel, not Excel). Then try re-entering the data. Once the date is stored (as a number), reformatting the cell in Excel will not change the underlying date stored. -- David Biddulph "Janneman" wrote in message ... 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I write 3/5 in a cell and have it look like 03-May back?
Hi,
Right click the cellFormatCustomin the "Type:" box type: m/d Tim "Janneman" wrote: 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! |
| Reply |
| 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 | |||
Hybrid Mode
