Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Negative numbers
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? Thanks |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
slot guy,
Have another look at the link JE gave you. There's a formula at the top you can use without using VB. Eric "slot guy" wrote: 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? |
#5
|
|||
|
|||
Formatting won't change it, since it's not a number. If you're using
XL02/3 use the non-VB method mentioned on the page. If you're using a prior or Mac version, I don't know of a way to do it in-place. In article , "slot guy" wrote: 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? |
#6
|
|||
|
|||
Thanks JE. I'm using Office 2000 so I don't have the non VB method.
"JE McGimpsey" wrote: Formatting won't change it, since it's not a number. If you're using XL02/3 use the non-VB method mentioned on the page. If you're using a prior or Mac version, I don't know of a way to do it in-place. In article , "slot guy" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Negative & Positive Numbers | New Users to Excel | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
How do I show negative numbers on a stacked graph | Charts and Charting in Excel | |||
Negative Numbers in Brackets - HELP! | Excel Discussion (Misc queries) | |||
can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions |