very custom formats

[Guest]

I need help with a custom format

If I enter the numbers 123 I want it to display 12-3 in the cell. (i.e simple custom format ##-#

But if I also want to be able to enter 123A into the same cell and have it display 12-3A (where A could be any letter A-Z)..

What would my custom format need to look like in order to do that
Or is there a better approach?

 

[Trevor Shuttleworth]

Not sure you can do what you want because the alphabetic character means the
value is no longer numeric, hence a custom number format won't work

Regards

Trevor

I need help with a custom format.

If I enter the numbers 123 I want it to display 12-3 in the cell. (i.e simple custom format ##-#)

But if I also want to be able to enter 123A into the same cell and have it

display 12-3A (where A could be any letter A-Z)...