In reply to a post by MHC:

inputting any number should return that number with % afterwards.

So you're saying inputting 0.5 in to a %-format cell results in '0.50%'?

Cm'on, admit it is inconsistent.

Why do we need '{}' instead of '[]'? Did it change sometime?

SF?

In reply to a post by XRaySpeX:

Why do we need '{}' instead of '[]'?

[red] is a BBCode tag- it wouldn't have shown, and turned everything after into red text!

Indeed, whereas {} brackets are used in Excel for array formulas (and probably other things I haven't discovered as yet).

In reply to a post by XRaySpeX:

In reply to a post by MHC:

inputting any number should return that number with % afterwards.

So you're saying inputting 0.5 in to a %-format cell results in '0.50%'?

Cm'on, admit it is inconsistent.

Cell formatted for percentage:

Entering 0.5 actually displays 0.500% (3dp set)
but entering .5 gives 50.000%

-0.5 gives -0.500%
-.5 gives -50.000%

There is certainly inconsistency.

I was referring to the string in my post ... I just could not remember the that was needed in front.

Sorry, misread your post. Thought you now need '{}' in Excel.

You needed [noparse] in front.

In reply to a post by MHC:

Entering 0.5 actually displays 0.500% (3dp set)
but entering .5 gives 50.000%

True, that's inconsistent.

Actually I did enter .5 in Excel but typed 0.5 when writing my post to make it clearer, never imagining that they would be any diff.

If you read my previous post, it does not make sense, but try doing a Quote and you will see that I put [noparse] in there - once, but it needed to be there twice!

This bottle of Swiss Red wine is having an effect.