| 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. |
| 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 | |||
Threaded Mode
