formatting changes not working in Excel '07

Microsoft Microsoft excel 2007 (pc)
February 17, 2010 at 07:54:29
Specs: Windows Vista
I am not able to format changes to change date or time in the columns. I have tried everything I can think of. Can you offer some help?

edited by moderator: Post moved from Windows Vista Forum

See More: formatting changes not working in Excel 07

February 17, 2010 at 14:11:04
Was the data entered by hand or copied into the cell?
If copied make sure the data is not in the form of TEXT.


Report •

February 17, 2010 at 14:18:39
I believe it was copied into a cell. I received it in an email. I figured out that the formula needed to be changed and that fancy word, "concatenated" was used. I believe I need some further training on Excel in order to use the formulae available.
Thank you for your help.

Report •

February 17, 2010 at 14:22:34

Enter the number 40226 in a previously unused cell (not one of your problem cells).

Now format it as a date. If it shows 17 Feb or similar, then your date formatting works, and as Mike suggested you likely have dates / times entered as text.

Excel has to recognize what is entered as a date or time, and it can be quite picky about what it accepts. If it doesn't recognize the entry as a date or time it leaves it as text which will not respond to format changes.

If it recognizes what is entered, as a date or time, Excel automatically converts the text to a number which it stores, but displays it according to the date/time format.

40226 is Excel's number for 17 Feb 2010. The numbers started at 1 for 01 January 1900.


Report •

Related Solutions

February 17, 2010 at 14:23:58

Post an example of what is in a couple of your problem cells.


Report •

Ask Question