| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help converting Number stored as Text to Date
Ok, I tried using the kb article for this, but obviously I'm still doing
something wrong.... please help if you can! I have a number 121101 in a cell -- when I right click the cell and select format cells it says it's formatted as a date, but the error checking says it's a number stored as text. I select the option in the error checking that says convert to number. I right click the cell again and it shows the format as general... I change it to date and the number 121101 becomes the date 7/24/2231 I want it to become 12/11/2001. Can someone please help me. I'm obviously not very good at excel and this is making me crazy!! Thanks in advance!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
| Number stored as text | Excel Discussion (Misc queries) | |||
| Converting number or text to a Date Format | New Users to Excel | |||
| Date stored as Text | Excel Discussion (Misc queries) | |||
| Number stored as text | Excel Discussion (Misc queries) | |||
Threaded Mode
