excel assumng everything is a time

[greenmark]

Help! This is driving me nuts.
Suddenly Excel is assuming everything I put in a cell is a time.
Its trivial, but really, really annoying.
Surely a spreadsheet should assume it's receiving a number?
As it has done for as long as I can remember.
What have I done?

Any advice would be gratefully received.

[footysystems]

Strange that

[greenmark]

...and when I reformat the column to be general, the next input turns into a time.

[footysystems]

...and when I reformat the column to be general, the next input turns into a time.

Had that before and not sure how i sorted it sure some savvy excel man will speak up

[greenmark]

Ok forget that, formatted as number. Back to normal. Soz.

[ShaunWhite]

Is it doing it on a new blank sheet? If so that's very strange. Otherwise you can try selecting the whole sheet and formatting it as a number type format. In fairness to excel a date/time is also just a number, and the way excel stores it it's the number of days since 1900-jan-00 with a mantissa that represents the fraction of the 24hrs within that day http://www.cpearson.com/excel/datetime.htm

[footysystems]

Ok forget that, formatted as number. Back to normal. Soz.

Excel lent

[ShaunWhite]

Just seen your post. Glad it's sorted. These niggly things can take ages and it's never expected so they have a habit of turning a 5minute job into a 1 hour job and messing up your day planner. Just be grateful you're not justifying your time on a timesheet and having to explain why you haven't finished.

[greenmark]

Cheers guys. Positive feedback as always.

[CallumPerry]

Took me WAY too long to work out Excel and VBA treats every cell as a variant, like you said time/date is just a number. Tripped myself up so many times not realising this, all part of the learning curve I guess but embarrassing how stuck it got me at times.