Change format of cell content

D

Dias

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.
 
D

Dave Peterson

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)
 
S

Suleman Peerzade

Hi,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove date format? 3
Format Cell/Number 10
Cell requires double click to 'activate' date format change 3
Column Date Format 1
cell format - can not change 3
converting text cell to numeric cell 5
Formula Bar - display of content 4
date format will not change in Excel 3

Top