| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Custom Formats
I have created a custom format for a cell that will be used in a general
company form. The custom format is for a credit card number and was written as follows: #### #### #### ####. When ever I type in a number 9999 9999 9999 9999 the final digit is convert to a zero. I do not understand why it is doing this. It is not being rounded. Can anyone help correct this very irritating formatting issue? Thanks -- bb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 custom toolbars | Excel Discussion (Misc queries) | |||
| Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) | |||
| Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) | |||
| Custom Header | Excel Discussion (Misc queries) | |||
| Shortcut for Filter- Custom Autofilter | Excel Discussion (Misc queries) | |||
Threaded Mode
