Custom Number Format

  • Thread starter Thread starter Excelders
  • Start date Start date
E

Excelders

It really won´t work. I keep getting the -Formula With Error - pop-up.

It always points to these parts in bold:

=left*(b4,1)*&"-"&mid*(b4,4,7)*


Am i screwing it up somehow ?
 
The formula works for me with my USA settings.

Any chance you use a different list separator.

If you use a semicolon, this might work for you:
=LEFT(B4;1)&"-"&MID(B4;4;7)
 
Back
Top