Software·43,881 discussions

Why can’t Excel automatically format a cell according to what you entered?

Locked

Why can’t Excel just put in the cell what you typed without screwing around with it?

Topic

Clarifications

In reply to Why can’t Excel automatically format a cell according to what you entered?

Clarifications

as in?

In reply to Why can’t Excel automatically format a cell according to what you entered?

is it a formula, text, numbers? a little more detail in what you are trying to do would be good so we can help you better.

Because it’s trying to be helpful

In reply to Why can’t Excel automatically format a cell according to what you entered?

and doesn’t always agree with what you think it should do.

Format the cell before you enter the data; job done. Or write some background code to the cell to format on what YOU want; job done. It’s a typical MS tool and it does things the way THEY want.

🙂

Other than the handling of time/dates, it does

In reply to Why can’t Excel automatically format a cell according to what you entered?

the problem is there are a lot of stupid and lazy people out there with little knowledge about anything that are looking for packages to do everything automatically for them. That is what MS is trying to do.

I have learned to loath MS Word for all the auto formatting crap that it tried to do, just because they are used to the average end user being clueless.

I’m loathing along with you.

In reply to Other than the handling of time/dates, it does

OpenOffice all the way.

[Author]

Replies