Change format of cell content
 

I have already prepared data sheet. I want change a column to date type for
make agraph. But can not change format of cells by right clicking. But if i
double click & enter it was changed. How I change type of content.

Change format of cell content
 

If you were changing text numbers to number numbers, you can use this technique:

Select an empty cell
Edit|Copy (xl2003 menus)
Select the offending range
Edit|Paste special|check add and values)



Dias wrote:

I have already prepared data sheet. I want change a column to date type for
make agraph. But can not change format of cells by right clicking. But if i
double click & enter it was changed. How I change type of content.

--

Dave Peterson

Change format of cell content
 

Hi,

Press key F2 in any cell and change the data.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Dias" wrote:

I have already prepared data sheet. I want change a column to date type for
make agraph. But can not change format of cells by right clicking. But if i
double click & enter it was changed. How I change type of content.