Numbers as Text

[Guest]

I am copying a column of numbers, formatted as Number w/ zero decimals, to a column formatted as Text. I am using Paste Special - Values only. The numbers are all four digits, such as 1101, 1105, 1111, 1123, etc. After the Paste, the numbers show up 'rounded' in the new (Text) column, with the last number always a 0. 1101 becomes 1100. 1105 becomes 1110. 1111 becomes 1110. 1123 becomes 1120. Any ideas why?

 

[Frank Kabel]

Hi
why do you want to put this numbers in a column formated as 'Text'?

 

[Guest]

The first two digits represent the month, and I always want the month to be two digits. 0123 for January, not 123


----- Frank Kabel wrote: ----

H
why do you want to put this numbers in a column formated as 'Text'

-
Regard
Frank Kabe
Frankfurt, German


Bill wrote

 

[Guest]

Actually, I took the project home Friday (from my office desktop) and worked on it on my laptop, and the numbers show up correctly in the text columns. Any insight into what feature my laptop might have that the desktop wouldn't that would cause the difference

Bil


----- Frank Kabel wrote: ----

H
why do you want to put this numbers in a column formated as 'Text'

-
Regard
Frank Kabe
Frankfurt, German


Bill wrote

 

[Dave Peterson]

Do you have any macros "helping" you?

In the problem pc, try opening excel in safe mode:

Close excel
windows start button|Run
excel /safe

Then open your workbook and copy|paste into it.

If you have a macro helping, you'll have to find it and decide what you want to
do. It could be in that workbook or it could be in a workbook that excel loads
whenever it starts.

You can use some techniques that Chip Pearson shares on his web site:
http://www.cpearson.com/excel/StartupErrors.htm

Essentially, you're going to move stuff out of your XLStart folder and uncheck
everything under Tools|Addins. (But keep track!)

Then one by one, you'll add one back and restart excel to see if that caused the
problem.