Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number 6 shows as s
Lately, whenever I start a new file and type a number or date in a cell with
a single digit 6, it shows as the letter s, for example 6/6/2006 shows as s/s/2006. If I preceed the number with a zero or in a multiple digit number, it shows as a regular 6. I have tried to change it using formatting the cell, but it does not change it. Can any one help. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number 6 shows as s
Zelfan, look under tools, autocorrect and see if 6 is being replaced by as s
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Zelfan" wrote in message ... Lately, whenever I start a new file and type a number or date in a cell with a single digit 6, it shows as the letter s, for example 6/6/2006 shows as s/s/2006. If I preceed the number with a zero or in a multiple digit number, it shows as a regular 6. I have tried to change it using formatting the cell, but it does not change it. Can any one help. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number 6 shows as s
Yes, that was the problem and it was corrected as soon as I deleted it
from autocorrect. Paul, thanks for your invaluable help. It was driving me crazy. Zelfan, Paul B wrote: Zelfan, look under tools, autocorrect and see if 6 is being replaced by as s -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Zelfan" wrote in message ... Lately, whenever I start a new file and type a number or date in a cell with a single digit 6, it shows as the letter s, for example 6/6/2006 shows as s/s/2006. If I preceed the number with a zero or in a multiple digit number, it shows as a regular 6. I have tried to change it using formatting the cell, but it does not change it. Can any one help. Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number 6 shows as s
your welcome, and thanks for the feedback
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "zelfan" wrote in message oups.com... Yes, that was the problem and it was corrected as soon as I deleted it from autocorrect. Paul, thanks for your invaluable help. It was driving me crazy. Zelfan, Paul B wrote: Zelfan, look under tools, autocorrect and see if 6 is being replaced by as s -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Zelfan" wrote in message ... Lately, whenever I start a new file and type a number or date in a cell with a single digit 6, it shows as the letter s, for example 6/6/2006 shows as s/s/2006. If I preceed the number with a zero or in a multiple digit number, it shows as a regular 6. I have tried to change it using formatting the cell, but it does not change it. Can any one help. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number format | Excel Discussion (Misc queries) | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions |