Format change 203.00 to 203-00

[acp20770]

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

thanks

[Beege]

acp,

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

Beege


"acp20770" <acp20770@discussions.microsoft.com> wrote in message
news:95C4FA1E-D9B0-47B0-B770-4EB533B2F4A3@microsoft.com...
> How do I reformat a group of numbers like 203.00 to 203-00?
>
> thanks

[Roger Govier]

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" <acp20770@discussions.microsoft.com> wrote in message
news:95C4FA1E-D9B0-47B0-B770-4EB533B2F4A3@microsoft.com...
> How do I reformat a group of numbers like 203.00 to 203-00?
>
> thanks