View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David R. S. David R. S. is offline
external usenet poster
 
Posts: 1
Default Format cell to Number

I have formatted a excel 2007 cell as a number. I enter a 16 number credit
card. The last 4 numbers a
6839

The cell automaticall changes the last 4 numbers to:
6830

When I press return or the tab key.

How Do I get the cell to not change the last number to a "0"