Friday, November 27, 2009

I have Excel 2003 - when I enter an account number in a cell the final number switches to a 0 ie I e

I have Excel 2003 - when I enter an account number in a cell the final number switches to a 0 ie I enter 345555 and it switches to 345550... I am trying to put together a spread sheet with all my credit card etc accounts and numbers on it. In the Cell under the account name I entered the account number... and for some reason the last number only changes to 0 no matter what I enter or try to renter....



Edit/Delete Message



I have Excel 2003 - when I enter an account number in a cell the final number switches to a 0 ie I enter 3455microsoft frontpage





You need to check



1- Tools %26gt; Options %26gt; Calculation %26gt; Interation



is not selected



2- Tools %26gt; Options %26gt; Edit %26gt; Fixed Decimals



Are set to zero



3- Enter your number after a space or ' or any other char



Enjoy my profile, I am the VBAXLMan



I have Excel 2003 - when I enter an account number in a cell the final number switches to a 0 ie I enter 3455windows vista home premium internet explorer



In Excel - select the area of cells that you would like to type numbers into and right click- then select "Format Cells"



make sure that it isn't set to anything that will round up or down.



Choose Text if you only want the cell to show a number, or choose number if you would like to use the cell in an equation.



edit-----



hmm that is pretty strange, have you tried opening a new excel spreadsheet to try?



if you would like to bypass the entire process you can create a custom cell format- and in the window type 0000000000000000 with 16 zeros, you can also put spaces in between every 4 numbers if you want.

No comments:

Post a Comment

 
mortgage loan