Dates entered in one format look different???

  • Thread starter Thread starter Tino
  • Start date Start date
T

Tino

Hi,

I have inherited a spreadsheet that, when I punch a date.. for example
12/8/68, it automatically converts it to some other format and I get
25062 or another number.

Can anyone help me with this?

I've tried cells all over that sheet and it only happens in this
sheet.. not the whole workbook.

I've tried pre formatting the cell as the date format I want..
dd/mm/yy and then entering the date but this hasn't helped.

I've tried punching the date into a fresh workbook where it appears
okay and then copying that cell into my affected sheet but it still
conerts it.

Any help would be much appreciated.

Thanks,

Tino
 
Dates are stored as numbers, you just need to "format" them to "look" the
way you want them. Select the range of numbers that should represent dates
and
click on the Format Cells... then select from the first tab date(s) and
whatever format you want...
HTH
 
Tried that... No good. Any other ideas?

Dates are stored as numbers, you just need to "format" them to "look" the
way you want them. Select the range of numbers that should represent dates
and
click on the Format Cells... then select from the first tab date(s) and
whatever format you want...
HTH
Click to expand...
 
Tino,

Have you looked at the VBA code (especially that of that particular
worksheet)?
Could be an Event in VBA that's overwriting your format.

John
 
Good idea but checked it and there is no VBA code behind that sheet?
It's very wierd??

Any other thoughts? Is there a way I can post an extract of the file
in this newsgroup or can I email a copy to you to check out?

Thanks
 
Tino,

Rec'd your workbook.
I see what your problem is but I don't know why (yet)
I'll take a look at it tomorrow.

For anyone else viewing this thread (that may be able to help)
There is no underlying code.
There are no Add-Ins

Whatever I format the cell as, it comes up as a number.
If I add a sheet and enter a date, it works fine.

John
 
Thanks John.. It's got me beat.

If anyone else is curious to see the file, just post your email
address.

Thanks.
 
Back
Top