very custom formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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


mrdigithead said:
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
Click to expand...
display 12-3A (where A could be any letter A-Z)...
 
Back
Top