Thanks for the link. Is there a way to change the format while in place
without using VB? I'm not experienced with it. Can a custom format be created
under "formating cells" to change the negative sign?

"JE McGimpsey" wrote:

Take a look he

http://www.mcgimpsey.com/excel/postfixnegatives.html

In article ,
"slot guy" wrote:

I have a report that I import into Excel and it displays negative numbers
with the sign to the right of the number (example: 8.8-). I would like the
number to be negative so I can use it. Can anyone help?