Microsoft Excel Replace (Ctrl H) Bug

Question

Hi,

I just wanted to point out a bug that I noticed whenever I used the Replace function.

If you use Replace (Ctrl H) to replace a number and add the ":" symbol. to it, the format of the cell will immediately change.

E.g. Replace all "3" with "3:" will get you "03:00".

This problem will not occur if you manually type a ":" to the "3".

Thank you.

Answer 1

Whether or not lots of people use excel.uservoice.com, that is what the product team now use as a significant input to their planning for updates.  So it is better to use it than other channels (like this one) which they do not monitor.

Office 365 now has a monthly update cycle (I believe) which is quite a change from the 1 year cycle of service releases in the past.  Whether this frequent update cycle is good or bad depends on the nature of your use, which is why corporate users can opt for a less frequent update cycle that enables them to test their applications in the new version before it gets rolled out.

Answer 2

Hi,

This is digressing from my problem but I saw the reply in my email.

@Bill I don't want to burst the bubble but do many Excel users usehttp://excel.uservoice.com?

I would like to point out that it would be great if you could constantly patch Microsoft Excel.

That way, if there are any silly mistakes, like the Inking issue, you can upload a new patch and update Excel.

@dogknees The Microsoft staff can just add a downvote/upvote meter at the very top of this topic and let anyone who has a Microsoft account give their 2 cents .

I am in favour of the down voting system as I have had a positive experience using down votes, in designing a certain game.

It has proven phenomenally useful.

Thank you.

Answer 3

Yes, inking was stupid - but since it was Office-wide stupidity I suspect it was forced upon the Excel team rather than they who thought it a good idea.

Answer 4

Thanks Bill. My concern arose from some of the posts here and a couple of "misguided" changes that have made it through in the last 12 months(thinking of the default inking issue in Office). At least MS are responding and fixing things.

Answer 5

That's a good point.

It isn't possible to "downvote".

The product team don't blindly implement the top voted items, however, and they have a record of being careful to maintain backwards compatibility - to the extent of not fixing some annoying bugs because some existing solutions might break.

It is possible to add comments to others' suggestions and I guess that is the route to take if you see a suggestion that you don't like.