Insert a hyphen in a cell display

Question

Hello,
I would like to modify the display format of the content of a cell:
There are 10 alphanumeric digits (starting with 0) that I want to display by separating the last 2 with a hyphen.
Example: 0000562301 transformed into 00005623-01

Thank you in advance

Configuration: Windows 7 / Firefox 43.0

Fahora · Accepted Answer

Hello,

=LEFT(A1,8)"-"&RIGHT(A1,2)

Best regards,

--
Our only limits are those we impose on ourselves.
Politeness and a thank you don't hurt. There is a button for "Resolved" to confirm that your issue is no longer one. Fahora

PHILOU10120 · Answer

Hello

Try this

=TEXT(A1,"00000000-##")
the text to convert is in A1

--
It's by forging that one becomes a blacksmith. - It's at the foot of the wall that one sees the mason - one always learns from their mistakes.

Mike-31 · Answer

Hello,

you can do it directly, select the range to be processed and right-click on your selection/Format Cells/Number tab/Custom and in the text box under Type: enter this format
00000000-00

--
A+
Mike-31

Not knowing is not a failure, failure is the refusal to learn.

acf · Answer

Thank you Philou, I forgot to mention that my numbers are already displayed in text format with a ' in front: it didn't work, therefore.

Mike-31 · Answer

Re,

currently how do you display these numbers in text format
how do you enter them

in the meantime try this
=TEXT(A1*1;"00000000-00")

Cheers
Mike-31

Not knowing is not a failure, failure is the refusal to learn.

Insert a hyphen in a cell display

5 answers

Connecting an external hard drive to a pc

Samsung smart switch app

Merge partitions

How to plug a usb cord into a tv

Disassemble the hp envy 27-b212nf to replace the ssd.

Control of my pc

How to disable youtube restricted mode on the network

Unable to uninstall norton

Electronic invoicing

Lowe tv screen stuck at startup