View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Liz J[_2_] Liz J[_2_] is offline
external usenet poster
 
Posts: 36
Default Negative Numbers

I have a column that has both negative and positive numbers. All of the
negative numbers, however, have the negative sign to the right of the number
instead of at the front. For example "3,445.45-" instead of "-3,445.45."
How do I get the negatives to switch to the front of the number? Is there a
formula or a format available?

Thank you for all of your help!