ExcelBanter - Default Number

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Default Number (https://www.excelbanter.com/excel-worksheet-functions/207955-default-number.html)

Jodie

Default Number

I am putting together a worksheet for a community group. I need to input
credit card numbers and when I input the last number, it automatically
defaults to zero- "0". How do I correct this?
Thank you for your prompt response.
Jodie Buehler

Gary''s Student

Default Number

Begin each number with a single quote (an apostrophe)
--
Gary''s Student - gsnu200810

All times are GMT +1. The time now is 09:59 AM.