Excel date display

JamoLew

Hi all, hoping for some guidance/help

I have an excel spreadsheet set up for my accounts etc and need some help with the way that the dates display.

For most of my cells, I have managed to get it to display with the  'rd and 'th etc in small letter above and to the right of the number (see below)
However, I have no idea how I did it and want to made a 'nd (for 2nd)
I can't spot any specific formatting in the cells either

Any clues/ideas ? 

Thanks

JGB1955

What happens if  you drag the cells up from  3rd?

[Deleted User]

Hi,

I don't use Excel, but here's what my pal google says:

How do you write 1st 2nd and 3rd 4 in Excel?

Excel subscript shortcut

1. Select one or more characters you want to format.
2. Press Ctrl + 1 to open the Format Cells dialog box.
3. Then press either Alt + E to select the Superscript option or Alt + B to select Subscript.
4. Hit the Enter key to apply the formatting and close the dialog.

Andy_L

I would recommend you don't bother and just put the full date in one cell Keeping the day separate and adding superscripts is going to cause all sorts of problems further down the line when it comes to sorting, searching & sharing your data.

RobM99

Highlight the cell, click "Number" in the ribbon at the top, there are options for the date therein.

JamoLew

Andy_L said:

I would recommend you don't bother and just put the full date in one cell Keeping the day separate and adding superscripts is going to cause all sorts of problems further down the line when it comes to sorting, searching & sharing your data.

I'm keeping it simple for now - so I cant see that being an immediate issue 

RobM99 said:

Highlight the cell, click "Number" in the ribbon at the top, there are options for the date therein.

Tried there - nothing obvious - I want to keep it to just a simple day and not have the month/year included

frugalmacdugal said:
Hi,

I don't use Excel, but here's what my pal google says:

How do you write 1st 2nd and 3rd 4 in Excel?

Excel subscript shortcut

1. Select one or more characters you want to format.
2. Press Ctrl + 1 to open the Format Cells dialog box.
3. Then press either Alt + E to select the Superscript option or Alt + B to select Subscript.
4. Hit the Enter key to apply the formatting and close the dialog.

Tried that - was one of the first things I came across but it doesn't work/help

JGB1955 said:

What happens if  you drag the cells up from  3rd?

Doesn't seem to do what I wanted

Thanks all - I kind of found a workaround by just copy/pasting from Word which seems to automatically make the n and d small when I type the 2nd in there

IvanOpinion

Does this help?
http://blog.thejaytray.com/excel-format-dates-include-st-ndrd-th/

WaywardDriver

Frugalmacdugal's suggestion works for me - type 3 then Ctrl+1, select Superscript, type rd, Enter.
But like others caution against non-standard use of dates.

Andy_L

JamoLew said:

Andy_L said:

I would recommend you don't bother and just put the full date in one cell Keeping the day separate and adding superscripts is going to cause all sorts of problems further down the line when it comes to sorting, searching & sharing your data.

I'm keeping it simple for now - so I cant see that being an immediate issue 

Really? Compare what you're having to with c&p'ing from word to get the superscripts with typing 31/12/20 into one cell. Its quicker, easier & ensures that, this time next year, you won't be asking here about an easy way of adding month & year data into a spreadsheet that only has the day in the date column ;-)

Andy_L

If you want to do it manually
type "2nd" into the cell
highlight the "nd" in the formula bar (so just the "nd" is gray)
right click on the gray highlighted bit>format cells> tick the superscript box

JamoLew

Andy_L said:

JamoLew said:

Andy_L said:

I would recommend you don't bother and just put the full date in one cell Keeping the day separate and adding superscripts is going to cause all sorts of problems further down the line when it comes to sorting, searching & sharing your data.

I'm keeping it simple for now - so I cant see that being an immediate issue 

Really? Compare what you're having to with c&p'ing from word to get the superscripts with typing 31/12/20 into one cell. Its quicker, easier & ensures that, this time next year, you won't be asking here about an easy way of adding month & year data into a spreadsheet that only has the day in the date column ;-)

Thing is - I don't want/need the month/year portion, however:

Andy_L said:

If you want to do it manually
type "2nd" into the cell
highlight the "nd" in the formula bar (so just the "nd" is gray)
right click on the gray highlighted bit>format cells> tick the superscript box

Spot on -- perfect -- thanks a bunch