delta symbol

[Rhots]

Hi, can anyone tell me how to get the delta symbol to stop showing up as a capital D?
Thanks,
Rick

 

[Rick Rothstein]

Hi, can anyone tell me how to get the delta symbol to stop showing up a capital D?

I think we need a little more details Rick. At minimum, show up where and how did it get there? If you have code or formulas, posting them in addition to your description would be helpful as too.

 

[Rhots]

Sorry, I have a cell with data validation from a list. In the list I can add the delta symbol after a digit and it shows properly. But in the cell refering to the list, the symbol shows up as a capital D

 

[shg]

Format the cell (or character within a cell) to use font Symbol, or use the UNICODE delta character (U+0394).

EDIT:

Sorry, I have a cell with data validation from a list.

UNICODE.

 

[Rick Rothstein]

But in the cell refering to the list, the symbol shows up as a capital D

That would be related to the "how did it get there" part of my question to you. Exactly how are you "adding" the delta symbol after the digit?

 

[Rhots]

from the greekc symbol list, sure wish I could post with an attachment

 

[Rick Rothstein]

from the greekc symbol list, sure wish I could post with an attachment

That is where it came from... I am interested in the method or code that you used to put it into the cell.

 

[Rhots]

I just typed in 240, then did a symbol insert

 

[shg]

If you do ...

Insert > Symbol
Font: (normal text)
from: Unicode (hex)
Character: 394

... it will work fine.

 

[Rhots]

I believe I did, character code 0044 from unicode (hex), according to the dialogue box.....I could make this work as suggested from above by changing my font to symbol in the data validation cell, but in my list there is also a "Y" which then shows up as a greek Y