Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Re-format cell to a number | Excel Worksheet Functions | |||
Cell Number format | Excel Discussion (Misc queries) | |||
Format a cell with a custom number format | Excel Worksheet Functions | |||
Format Row If Cell Contains Even Number | Excel Discussion (Misc queries) | |||
CELL/NUMBER FORMAT | Excel Discussion (Misc queries) |