Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell contents so that Excel recognises it as a date
Changing the format the cell won't change the value of the cell.
After you reformat the cell, try reentering the data. Depending on what you have in the cell, hitting F2, then enter may be enough. Mifty wrote: Hi there, Is there a simple way to convert data in to recognisable date format? What I want to do is calculate the difference between start and finish dates, but the data has already been entered and excel is not recoginsing it as a date even when it has been re-formatted as a date. I would be so grateful for any help! :-) -- Mifty -- Dave Peterson |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell contents so that Excel recognises it as a date
You can also wrap the cell references in the DATEVALUE function such as:
=DATEVALUE(B1)-DATEVALUE(A1) where B1 is the end date as text and A1 is the beginning date as text. Also if you have a whole column (say column A) of dates that you want to convert you can enter =DATEVALUE(A1) and so forth in another column to get dates (of course this column must be formatted as a date. "Dave Peterson" wrote: Changing the format the cell won't change the value of the cell. After you reformat the cell, try reentering the data. Depending on what you have in the cell, hitting F2, then enter may be enough. Mifty wrote: Hi there, Is there a simple way to convert data in to recognisable date format? What I want to do is calculate the difference between start and finish dates, but the data has already been entered and excel is not recoginsing it as a date even when it has been re-formatted as a date. I would be so grateful for any help! :-) -- Mifty -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell contents so that Excel recognises it as a date
Thanks for the reply.
-- Mifty "Dave Peterson" wrote: Changing the format the cell won't change the value of the cell. After you reformat the cell, try reentering the data. Depending on what you have in the cell, hitting F2, then enter may be enough. Mifty wrote: Hi there, Is there a simple way to convert data in to recognisable date format? What I want to do is calculate the difference between start and finish dates, but the data has already been entered and excel is not recoginsing it as a date even when it has been re-formatted as a date. I would be so grateful for any help! :-) -- Mifty -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing cell contents so that Excel recognises it as a date
Erin,
Thanks for the reply. Will try this on Monday at work and will let you know how it goes. Cheers -- Mifty "Erin Searfoss" wrote: You can also wrap the cell references in the DATEVALUE function such as: =DATEVALUE(B1)-DATEVALUE(A1) where B1 is the end date as text and A1 is the beginning date as text. Also if you have a whole column (say column A) of dates that you want to convert you can enter =DATEVALUE(A1) and so forth in another column to get dates (of course this column must be formatted as a date. "Dave Peterson" wrote: Changing the format the cell won't change the value of the cell. After you reformat the cell, try reentering the data. Depending on what you have in the cell, hitting F2, then enter may be enough. Mifty wrote: Hi there, Is there a simple way to convert data in to recognisable date format? What I want to do is calculate the difference between start and finish dates, but the data has already been entered and excel is not recoginsing it as a date even when it has been re-formatted as a date. I would be so grateful for any help! :-) -- Mifty -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have a calendar pop up in a cell to pick & insert a date in excel | Excel Worksheet Functions | |||
How do I stop excel automatically changing my date to 2005? | Excel Discussion (Misc queries) | |||
How can I get excel to apply values in a cell before or after date | Excel Worksheet Functions | |||
Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |