Change the format of the cell

N

nick

Hi,

I have a cell with 8 characters "12345678" and i need to format it as
12-345678. How do i do this? Someone plz help
 
C

CLR

Right-click > FormatCells > NumberTab > Custom > put ##-###### in the Type:
window > ok

Vaya con Dios,
Chuck, CABGx3
 
Top