| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting issue- date format dominates
Hi,
I'm trying to put general numbers in a column as follows : 0, 1, 2-3 and 4+. 2-3 keeps changing to Feb 3rd no matter that I keep formatting General. How can I stop this? Please help! Thanks, Chris -- Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formatting issue- date format dominates
precede the entry with an apostrophe ' or format as text
-- Regards, Peo Sjoblom "learningaccess" wrote in message ... Hi, I'm trying to put general numbers in a column as follows : 0, 1, 2-3 and 4+. 2-3 keeps changing to Feb 3rd no matter that I keep formatting General. How can I stop this? Please help! Thanks, Chris -- Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formatting issue- date format dominates
thank you, but i need the format in general for a map point application. map
point won't map 2-3 and 4+ as text but it worked no problem the other day with general format. Why won't general format stick? -- Thanks! "Peo Sjoblom" wrote: precede the entry with an apostrophe ' or format as text -- Regards, Peo Sjoblom "learningaccess" wrote in message ... Hi, I'm trying to put general numbers in a column as follows : 0, 1, 2-3 and 4+. 2-3 keeps changing to Feb 3rd no matter that I keep formatting General. How can I stop this? Please help! Thanks, Chris -- Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formatting issue- date format dominates
2-3 is not a number in Excel so Excel guesses what you are trying to do and
it guesses that you are trying to enter a date. Btw, why would you need general format? -- Regards, Peo Sjoblom "learningaccess" wrote in message ... thank you, but i need the format in general for a map point application. map point won't map 2-3 and 4+ as text but it worked no problem the other day with general format. Why won't general format stick? -- Thanks! "Peo Sjoblom" wrote: precede the entry with an apostrophe ' or format as text -- Regards, Peo Sjoblom "learningaccess" wrote in message ... Hi, I'm trying to put general numbers in a column as follows : 0, 1, 2-3 and 4+. 2-3 keeps changing to Feb 3rd no matter that I keep formatting General. How can I stop this? Please help! Thanks, Chris -- Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formatting issue- date format dominates
Someone please help! I just need the following in general format:
0, 1, 2-3 and 4+ 2-3 keeps changing to Feb 3rd. I just need 2-3 and 4+ in General number format. Worked the other day ... no problem. Don't know what the deal is today. Thank you. -- Thanks! "Peo Sjoblom" wrote: 2-3 is not a number in Excel so Excel guesses what you are trying to do and it guesses that you are trying to enter a date. Btw, why would you need general format? -- Regards, Peo Sjoblom "learningaccess" wrote in message ... thank you, but i need the format in general for a map point application. map point won't map 2-3 and 4+ as text but it worked no problem the other day with general format. Why won't general format stick? -- Thanks! "Peo Sjoblom" wrote: precede the entry with an apostrophe ' or format as text -- Regards, Peo Sjoblom "learningaccess" wrote in message ... Hi, I'm trying to put general numbers in a column as follows : 0, 1, 2-3 and 4+. 2-3 keeps changing to Feb 3rd no matter that I keep formatting General. How can I stop this? Please help! Thanks, Chris -- Thanks! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formatting issue- date format dominates
You have already received an explanation of this. In Excel, 2-3 and 4+ are
NOT numbers. You cannot enter 2-3 in General format (except preceded by an apostrophe) without it going wrong. Whatever you did "the other day" was no different - you have just confused yourself. "learningaccess" wrote in message ... Someone please help! I just need the following in general format: 0, 1, 2-3 and 4+ 2-3 keeps changing to Feb 3rd. I just need 2-3 and 4+ in General number format. Worked the other day ... no problem. Don't know what the deal is today. Thank you. -- Thanks! "Peo Sjoblom" wrote: 2-3 is not a number in Excel so Excel guesses what you are trying to do and it guesses that you are trying to enter a date. Btw, why would you need general format? -- Regards, Peo Sjoblom "learningaccess" wrote in message ... thank you, but i need the format in general for a map point application. map point won't map 2-3 and 4+ as text but it worked no problem the other day with general format. Why won't general format stick? -- Thanks! "Peo Sjoblom" wrote: precede the entry with an apostrophe ' or format as text -- Regards, Peo Sjoblom "learningaccess" wrote in message ... Hi, I'm trying to put general numbers in a column as follows : 0, 1, 2-3 and 4+. 2-3 keeps changing to Feb 3rd no matter that I keep formatting General. How can I stop this? Please help! Thanks, Chris -- Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel date format issue | Excel Discussion (Misc queries) | |||
| date format issue | Excel Discussion (Misc queries) | |||
| Date format issue | New Users to Excel | |||
| DATE FORMAT issue | Excel Worksheet Functions | |||
| Date format issue | Excel Worksheet Functions | |||
Hybrid Mode
