Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Unable to format dates
Hi all.
I'm using Excel 2003. I opened a file that has a column of dates and they had been reformated to Microsoft's underlying general number. I've tried reformatting as adate and doing text to columns, but neither worked. Also, the date shows in the formula bar, but not the cell. Any ideas? Thanks in advance. -- Sincerely, Michael Colvin |
#2
|
|||
|
|||
Michael,
Try this. Type 1 into a spare cell, and copy that cell. Select the range of dates. Goto EditPastespecial, and click the Multiply option Exit Now format the dates into a date format. Clearf the 1 from the cell. -- HTH RP (remove nothere from the email address if mailing direct) "Michael" wrote in message ... Hi all. I'm using Excel 2003. I opened a file that has a column of dates and they had been reformated to Microsoft's underlying general number. I've tried reformatting as adate and doing text to columns, but neither worked. Also, the date shows in the formula bar, but not the cell. Any ideas? Thanks in advance. -- Sincerely, Michael Colvin |
#3
|
|||
|
|||
You probably have formulas displayed. To turn them off:
Choose ToolsOptions On the View tab, under 'Window options' remove the check mark from Formulas Click OK Michael wrote: Hi all. I'm using Excel 2003. I opened a file that has a column of dates and they had been reformated to Microsoft's underlying general number. I've tried reformatting as adate and doing text to columns, but neither worked. Also, the date shows in the formula bar, but not the cell. Any ideas? Thanks in advance. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
Thank you Bob and Debra very much. It's been a long day. Somehow I did have
formuas checked on the view tab. You all are great! "Debra Dalgleish" wrote: You probably have formulas displayed. To turn them off: Choose ToolsOptions On the View tab, under 'Window options' remove the check mark from Formulas Click OK Michael wrote: Hi all. I'm using Excel 2003. I opened a file that has a column of dates and they had been reformated to Microsoft's underlying general number. I've tried reformatting as adate and doing text to columns, but neither worked. Also, the date shows in the formula bar, but not the cell. Any ideas? Thanks in advance. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
the dates on cell format make different dates. | New Users to Excel | |||
Can I change a column of dates from USA to UK format? | Excel Discussion (Misc queries) | |||
How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
Dates in 2005 format cells are not entering correctly. | Excel Worksheet Functions | |||
Any way to force European format dates in sheets? | New Users to Excel |