So my boss showed me a spreadsheet that has a whole bunch of Credit card numbers in a column. The problem is; on many of the cells; it forces the last digit in the cell to be a 0. You can try and change it but it always goes back to 0. I even put the column in Note pad; made a change; and tried to re-paste. Same thing; the changes did not stick but turned back into 0.

 

UC

What format do you have your cells in?

 

My guess is it is in the formatting of the cells. Make sure it is not set to custom or anything like that

 

if you do not want it to "calculate" place a ' in the cell prior to what you add....

 

Format is Number with no decimals

 

Good answer

 

Format the cell(s) as text, Excel leaves the cell as entered or typed, also the adding the ' works, but if you need it for reports will look off.

 

Yea he didn't go for the ' idea. Who cares, I spent 3 minutes on the subject; I'm done working for the day.

 

Email it to me, I'll see if I can fix it, then e-mail it back.

 

Now now Pss; we have a history and we both know you can't be trusted on your word.

 

Is it rounding to the nearest tenth?

 

Yes, formatting to number with no decimal is the way to go, then you can align to either left or right, select your column by putting the mouse at the top of the column and clicking on it (the whole column should turn a different color) and then right click, format cells will get you to the number and alignment that you need.

Mrs. Zap!

(Disclaimer: The views expressed above are solely that of mrs. zap! and is in no way reflective of the opinion of management or ...zap!)

 

Just as well, my next thread was going to be "What mods should I do with unlimited resources?"