Format change 203.00 to 203-00
 

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

thanks

Format change 203.00 to 203-00
 

acp,

You could format as text, replace "." with "-"

Beege


"acp20770" wrote in message
...
How do I reformat a group of numbers like 203.00 to 203-00?

thanks

Format change 203.00 to 203-00
 

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 Govier


"acp20770" wrote in message
...
How do I reformat a group of numbers like 203.00 to 203-00?

thanks