| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
end number keeps changing to '0'
Hello,
I am trying to keep trackof credit card numbers, i put in a custom formating that looks like this: ####-####-####-#### so i can just type the numbers in without having to type '-'. The only problem is that is always turns the last number into a '0' zero. for instance if the number is: 4519-3589-2000-1875 the formula changes the number to this: 4519-3589-2000-1870 Thank you, shivaraj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number changing digits on paste from web apx file field | Excel Discussion (Misc queries) | |||
| How to keep "text" number from changing to date.... | New Users to Excel | |||
| Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
| edit number in cell without it changing to text | Excel Discussion (Misc queries) | |||
| Changing a formulas result to be a static number | Excel Discussion (Misc queries) | |||
Threaded Mode
