It's a caracter used in Portugal to shorten some words like week days. We use
as well caracter º for ordinal numbers, first we write 1º. But forget the
caracter and use the normal "a"

Thanks

"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