close

Hi,

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

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

Vaya con Dios,
Chuck, CABGx3
quot;nickquot; wrote:

gt; Hi,
gt;
gt; I have a cell with 8 characters quot;12345678quot; and i need to format it as
gt; 12-345678. How do i do this? Someone plz help

Thank You

quot;CLRquot; wrote:

gt; Right-click gt; FormatCells gt; NumberTab gt; Custom gt; put ##-###### in the Type:
gt; window gt; ok
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;nickquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I have a cell with 8 characters quot;12345678quot; and i need to format it as
gt; gt; 12-345678. How do i do this? Someone plz help

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()