Formatting of Dates

G

Guest

I seem to have a very annoying problem with dates on excel.

I have a simple spreadsheet which is listing invoices for me on a monthly
basis. The column is formated as date "dd/mm/yyyy", when i enter the date
into a cell within this column it will display correctly in the formula bar
but on the cell i only see a 5 chracter number. For example 01/06/2007 is
being displayed in the cell as 39234. I have tried diferent date formats but
it doesnt seem to change anything.

If anyone can help with this i would be truly greatful.

Thanks in advance
Hervinder
 
R

Ron Rosenfeld

I seem to have a very annoying problem with dates on excel.

I have a simple spreadsheet which is listing invoices for me on a monthly
basis. The column is formated as date "dd/mm/yyyy", when i enter the date
into a cell within this column it will display correctly in the formula bar
but on the cell i only see a 5 chracter number. For example 01/06/2007 is
being displayed in the cell as 39234. I have tried diferent date formats but
it doesnt seem to change anything.

If anyone can help with this i would be truly greatful.

Thanks in advance
Hervinder

Select Tools/Options/View
Window Options

and DEselect Formulas
--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top