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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help converting Number stored as Text to Date
Select the cell(s) and then
Data|text to columns select fixed width next next select date & YMD Finish You should have a date Mike "LuvHaleiwa" wrote: 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!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help converting Number stored as Text to Date
Ooops
for your date you should select MDY "LuvHaleiwa" wrote: 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!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help converting Number stored as Text to Date
Thank you sooooo much! Worked perfectly!!!
Kara "Mike H" wrote: Select the cell(s) and then Data|text to columns select fixed width next next select date & YMD Finish You should have a date Mike "LuvHaleiwa" wrote: 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!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help converting Number stored as Text to Date
You're most welcome and thanks for the feedback.
Mike "LuvHaleiwa" wrote: Thank you sooooo much! Worked perfectly!!! Kara "Mike H" wrote: Select the cell(s) and then Data|text to columns select fixed width next next select date & YMD Finish You should have a date Mike "LuvHaleiwa" wrote: 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!! |
Reply |
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) |