|I took a look at your spreadsheet. Let's go over your original post, bit by bit:|
Running office 7. I have one spread sheet created by someone else that when you paste an number from outside of the program (word outlook, etc) it appears as a date
If I right-click on any cell in any sheet (except for the Comments sheet) and choose "Format cells", it shows Date - 14-Mar-01. Every cell, even ones that already have text in them. As far as I can tell, only the Comments sheet has cells that are not formatted as Date - 14-Mar-01.
That would explain why all numbers are being converted to Dates. Are you seeing a different format when you check the cells?
based on the nuber of days sinceY2K not the format that is set in the cell. So 18 comes in as January 18, 2000.
No, it is converting them to the number of days since 1900, just as I would expect Excel to do. If I enter 18 in a cell, I see 18-Jan-00 in the cell and 1/18/1900 in the formula bar. 0/0/1900 is day 0 for Excel, 1/1/1900 is day 1, etc.
if there is a decimal it adds a time element.
As I would expect a cell formatted as a Date to do. It will show the time in the formula bar, but not in the cell if it is formatted as Date - 14-Mar-01.
If you paste to the Formula bar it holds the existing foromat.
You can change the format afterwards.
I have varified that the cell does not have a date format in it
How have you verified this? If I click in the box above the row numbers to select the entire sheet and choose Format Cells, every sheet except for Comments is showing that the entire sheet is formatted as Date - 14-Mar-01.
and have tried setting different number formats before pasting.
Which works just fine. I formatted a cell as Currency before pasting in an 18 and it displayed $18.00 as expected.
As far as I can tell, there is nothing wrong with your workbook, although it is a little odd that every sheet except for one (Comments is entirely formatted as Date - 14-Mar-01.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.