Format Cells (Number)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wlotto - 26 Feb 2004 03:52 GMT

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.

Reply to this Message

Frank Kabel - 26 Feb 2004 07:44 GMT

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

Signature

Regards
Frank Kabel
Frankfurt, Germany

> I can't change the following date to a different Number
> format. [Format Cells>Number...] How could I change it to
[quoted text clipped - 6 lines]
>
> Thanks.

Reply to this Message

Jon Peltier - 28 Feb 2004 01:49 GMT

Even quicker:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

> Hi
> the cell is probably formated as text. Try the following:
[quoted text clipped - 3 lines]
> - select your column of dates
> - goto 'Edit-Paste Special' and choose 'Multiply' as action

Reply to this Message