That will solve your problem, won't it?

To the best of my knowledge and belief, I don't think it is possible.

However I have learnt not to say 'never'...

"Lemmesee" wrote:

is it possible to make a custom format that omits the first 5 chars?

"Sheeloo" wrote:

I don't think this can be done...

I will be happy to learn a new trick if someone provides a solution.

"Lemmesee" wrote:

I need a format that omits all of the characters before a hyphen (-) and one
after it.
example;
001- ABC displayed as ABC

I can easily do this with a formula but I need to do it in a format.