Biff,

it returns a CODE of 170, and does look like lower case a when copied
into Excel (and zoomed).

Pete

On Dec 18, 11:21*pm, "T. Valko" wrote:
2ª

What is that superscript character after the number? With my poor eyesight,
it looks like a lowercase "a". What does that mean?

--
Biff
Microsoft Excel MVP

"henriques" wrote in message

...



In each line of column A of spread sheet is day of the month in format
ddmmyyyy. I need that in column B appears 2ª for Monday, 3ª for Tuesday,
4ª
for Wednesday, 5ª for Thursday, 6ª for Friday, S for Saturday, D for
Sunday
and H for Holiday. I tried with nasted IF and it works except for the
Holiday. Please assume month of December with Holidays at 1st December,
8th
December and 25th of December.
Thanks for help- Hide quoted text -

- Show quoted text -