How to change minus sign to delta sign?

Hello

I have some question about how to change - (minus sign) to delta sign in excel

I already search on google, but there is no one had ask for this topic. Please advice us.

Thanks.

- You will find this from "Insert > Symbols > Wingdings 3"

And about how to change the (-) sign to delta, here is I'm telling you:

- Insert a Delta symbol in any cell.

- Copy it.

- Select the cell, you want to change the negative sign to delta

- Press "CTRL+SHIFT+F" at once

- Click on "Number" tab.

- Choose "Custom" from "category"

- Type the below code there:

#,##0.00;#,##0.00;0

- Paste the delta sign after first ";"

#,##0.00;(Paste the delta symbol here)#,##0.00;0

- it will looks like this:

#,##0.00;▼#,##0.00;0

(for negative direction, Delta symbol is down)

Now Click on "OK" and it has done like below:

Please mark this post as answer/helpful if you found this helpful.

If my reply answers your question then please mark as "Answer", it would help others to find their solution easily from your experience.

Thanks

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 9, 2024 Views 322 Applies to: