Dates entered in one format look different???

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
 
J

JMay

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
 
T

Tino

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...
 
J

John Wilson

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
 
T

Tino

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
 
J

John Wilson

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
 
T

Tino

Thanks John.. It's got me beat.

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

Thanks.
 
Top