How do I reformat a group of numbers like 203.00 to 203-00? thanks
R Roger Govier Feb 16, 2006 #3 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
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
