Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Default Number
Begin each number with a single quote (an apostrophe)
-- Gary''s Student - gsnu200810 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Number Format for all WEorksheets | Excel Worksheet Functions | |||
Default number format | Excel Discussion (Misc queries) | |||
Default number format | Excel Discussion (Misc queries) | |||
number of iterations as default | Excel Worksheet Functions | |||
default number format | Excel Discussion (Misc queries) |