close

How do I reformat a group of numbers like 203.00 to 203-00?

thanks

acp,

You could format as text, replace quot;.quot; with quot;-quot;

Beegequot;acp20770quot; gt; wrote in message
...
gt; How do I reformat a group of numbers like 203.00 to 203-00?
gt;
gt; thanks
Hi

One way
Mark the block of cells you want to change.
Ctrl H to bring up Find and Replace
Enter the period . in the Find pane
Enter the dash - in the Replace Pane
Replace All

--
Regards

Roger Govierquot;acp20770quot; gt; wrote in message
...
gt; How do I reformat a group of numbers like 203.00 to 203-00?
gt;
gt; thanks

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

    software

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

    E-mail轉寄