Format Cells (Number)

  • Thread starter Thread starter wlotto
  • Start date Start date
W

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.
 
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
 
Even quicker:

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

- Jon
 
Back
Top