Format Cells (Number)

[wlotto]

I can't change the following date to a different Number
format. [Format Cells>Number...] How could I change it to
like, 12/26/00 or 36886?

26-Dec-2000

This is the beginning of a series of date and doesn't let
me create any valid X axis.

Thanks.

 

[Frank Kabel]

Hi
the cell is probably formated as text. Try the following:
- format the column as 'Date'
- enter the value 1 in an empty cell
- copy this cell (CTRL+C)
- select your column of dates
- goto 'Edit-Paste Special' and choose 'Multiply' as action

 

[Jon Peltier]

Even quicker:

Copy a blank cell (zero)
Select nonnumeric cell
Paste Special - Add

- Jon