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! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting issue- date format dominates
Wow... someone is in a bad mood! Have you heard of email etiquette? Really,
there is no need to be so nasty. I had no problems doing this in general the other day. Get a personality. -- Thanks! "Stephen" wrote: 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! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting issue- date format dominates
No offense but I am pretty sure you are wrong, I have never heard of anyone
being able to bypass this limitation and it also doesn't make any sense that it would work one day but not the other. 2-3 would always convert to a date but if you use 13-3 then it will stay the same because it cannot be interpreted as a date using US default regional settings. You still haven't answer why you would need general formatting for this, how come map point would need a specific format? -- Regards, Peo Sjoblom "learningaccess" wrote in message ... Wow... someone is in a bad mood! Have you heard of email etiquette? Really, there is no need to be so nasty. I had no problems doing this in general the other day. Get a personality. -- Thanks! "Stephen" wrote: 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! |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting issue- date format dominates
You need to look in a mirror. You want free, accurate advice, and you are
getting it. What more do you want? You're welcome to take your business elsewhere. But if you follow the advice given in this newsgroup, no matter how it's worded, you will never go wrong. -- Regards, Fred "learningaccess" wrote in message ... Wow... someone is in a bad mood! Have you heard of email etiquette? Really, there is no need to be so nasty. I had no problems doing this in general the other day. Get a personality. -- Thanks! "Stephen" wrote: 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 |