Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I abbreviate a year?
I am entering some data and need to abbreviate the year. Instead of 2009, I
need it to read '09, or '05, etc. I have selected "treat as Text," but that doesn't work. I seem to remember there was a way to do it, but for the life of me, I can't remember how. I would appreciate it if anyone could help me out. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I abbreviate a year?
Hi Yvonne,
Number format and select Date then Custom and set the required format. -- Regards, OssieMac "Yvonne" wrote: I am entering some data and need to abbreviate the year. Instead of 2009, I need it to read '09, or '05, etc. I have selected "treat as Text," but that doesn't work. I seem to remember there was a way to do it, but for the life of me, I can't remember how. I would appreciate it if anyone could help me out. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I abbreviate a year?
2 ways... I fyou just ant text type in two apostrophies
''09 will show up as '09 or change the format of the cell to be custom Format - Cell... |Number tab | Custom '00 Now if you type in a 9 it will show up '09 -- HTH... Jim Thomlinson "Yvonne" wrote: I am entering some data and need to abbreviate the year. Instead of 2009, I need it to read '09, or '05, etc. I have selected "treat as Text," but that doesn't work. I seem to remember there was a way to do it, but for the life of me, I can't remember how. I would appreciate it if anyone could help me out. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I abbreviate a year?
Hi,
The real question is how are you entering the dates? Are they Excel dates or are you entering them as numbers only. In otherwords, 1/1/2009 which you want to display as '09 or are you typing in 2009 and wanting that to display as '09? If you are trying to enter 2009 and have it show as '09 then you can create a formula in another cell assuming that 2009 is in A1: =TEXT(RIGHT(A1,2),"'00") or ="'"&RIGHT(A1,2) or you could enter =--("1/1/"&A1) and then format the cell to 'yy the advantage to this last one is that you actually have a date in the cell. If you want to enter a date in A1 and see it as '09 then use the same format as shown above: 'yy If you just want to enter '09 in the cell format the cell as text and type '09 into A1. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Yvonne" wrote: I am entering some data and need to abbreviate the year. Instead of 2009, I need it to read '09, or '05, etc. I have selected "treat as Text," but that doesn't work. I seem to remember there was a way to do it, but for the life of me, I can't remember how. I would appreciate it if anyone could help me out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Abbreviate [Number] Billions to [#] Bn | Excel Discussion (Misc queries) | |||
Custom Number Format to abbreviate to Millions | Excel Worksheet Functions | |||
How do I abbreviate words? | Excel Discussion (Misc queries) | |||
I am trying to abbreviate text in my description column. | Excel Worksheet Functions | |||
Can I abbreviate one value in a data series? | Charts and Charting in Excel |