| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting numbers
I am trying to select a series of years for the X axis (e.g. 98-00, 99-01,
00-03, etc.). What format category should I choose for the cells, so that "01-03" doesn't show up as "38355"? All of the other cells show-up correctly when formatted as "number." I went down the list and tried each category, to no avail. Thank you. -- Andrea |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting negative numbers in Excel | Excel Discussion (Misc queries) | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Formatting: when typing the numbers "2004" then a period or simili | Excel Discussion (Misc queries) | |||
| formatting numbers | Excel Worksheet Functions | |||
| Why does 26000 display as 260.00 after formatting for numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
