View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sameer[_3_] Sameer[_3_] is offline
external usenet poster
 
Posts: 2
Default format and paste problems

Select columnFormat CellsNumber (Tab)Under Category select TimeOK
This should help.

"Natalie" wrote:

Hi,

I'm using excel 2007, have been working on a spreadsheet for several weeks.
The data is columns of numbers one being a time code column. There are 6
sheets in the workbook with approx. 6 columns and 200 rows data, so they are
not huge. All of a sudden I opened the spreadsheet and my time column had
reverted to numbers. I can change that back, but it changes again every time
I save, shutdown and reopen. I also cannot cut and paste data between
spreadsheets or even onto a new spreadsheet. I usually get one column done
then it just pastes blank cells. The numbers are simple, and when I try paste
special it comes up like I'm pasting a picture. I have tried creating a new
file and saving it as 2007 and compatible but it still ends up with the same
issues. Can anyone help??