Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Space between decimal numbers
Hi:
Whenever I am typing any number in excel such as 14.00. Its putting double spaces between 14.00 (e.g., 14. 00). How can I correct this. |
#2
|
|||
|
|||
Do formatcellsnumber and select 2 decimal number
Regards, Peo Sjoblom "Timmy" wrote: Hi: Whenever I am typing any number in excel such as 14.00. Its putting double spaces between 14.00 (e.g., 14. 00). How can I correct this. |
#3
|
|||
|
|||
Did this not help me.
"Peo Sjoblom" wrote: Do formatcellsnumber and select 2 decimal number Regards, Peo Sjoblom "Timmy" wrote: Hi: Whenever I am typing any number in excel such as 14.00. Its putting double spaces between 14.00 (e.g., 14. 00). How can I correct this. |
#4
|
|||
|
|||
Hi Timmy,
Guess that means "Did that. Didn't help me." because as a question it doesn't mean much to me. (if English is not your language, what language are you coming from?) In fact do you use a comma for thousands separator and a period for decimal fraction. Try hitting F2 then Enter, after the formatting. Formatting does not actually change until reentered between text and number. Will assume that you haven't change justification to left, right, or center and that is left justified as text, the better test is to check with ISTEXT. If you still have the original what do you see for Format, cells, custom and what do you have for =ISTEXT(A1) if A1 is the cell. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Timmy" wrote in message ... Did this not help me. "Peo Sjoblom" wrote: Do formatcellsnumber and select 2 decimal number Regards, Peo Sjoblom "Timmy" wrote: Hi: Whenever I am typing any number in excel such as 14.00. Its putting double spaces between 14.00 (e.g., 14. 00). How can I correct this. |
#5
|
|||
|
|||
It doe not matter what language I am speaking. Bottom line is that when I am
typing the numbers, place a period, and hit next number, it automatically puts two spaces. I have checked the options, formatting, etc It's not helping me. Its pain that whenever I have a number after typing I delete those two spaces and after that it's fine. "David McRitchie" wrote: Hi Timmy, Guess that means "Did that. Didn't help me." because as a question it doesn't mean much to me. (if English is not your language, what language are you coming from?) In fact do you use a comma for thousands separator and a period for decimal fraction. Try hitting F2 then Enter, after the formatting. Formatting does not actually change until reentered between text and number. Will assume that you haven't change justification to left, right, or center and that is left justified as text, the better test is to check with ISTEXT. If you still have the original what do you see for Format, cells, custom and what do you have for =ISTEXT(A1) if A1 is the cell. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Timmy" wrote in message ... Did this not help me. "Peo Sjoblom" wrote: Do formatcellsnumber and select 2 decimal number Regards, Peo Sjoblom "Timmy" wrote: Hi: Whenever I am typing any number in excel such as 14.00. Its putting double spaces between 14.00 (e.g., 14. 00). How can I correct this. |
#6
|
|||
|
|||
Check into ToolsAutocorrect. See if there's an entry which changes a period
to a period followed by two spaces. This could cause your problem. While you're correct that it doesn't matter what language you speak, it does matter whether you communicate effectively. Sometimes when we know your native tongue, it helps us understand your post better. What David is telling you is that you're not communicating clearly enough to allow effective analysis of your problem. This group provides the quickest, cheapest and most effective advice of any service on the net. To get this free advice, all you have to do is be pleasant and state your problem clearly. You may not think that's fair, but that's the way this board works. -- Regards, Fred Please reply to newsgroup, not e-mail "Timmy" wrote in message ... It doe not matter what language I am speaking. Bottom line is that when I am typing the numbers, place a period, and hit next number, it automatically puts two spaces. I have checked the options, formatting, etc It's not helping me. Its pain that whenever I have a number after typing I delete those two spaces and after that it's fine. "David McRitchie" wrote: Hi Timmy, Guess that means "Did that. Didn't help me." because as a question it doesn't mean much to me. (if English is not your language, what language are you coming from?) In fact do you use a comma for thousands separator and a period for decimal fraction. Try hitting F2 then Enter, after the formatting. Formatting does not actually change until reentered between text and number. Will assume that you haven't change justification to left, right, or center and that is left justified as text, the better test is to check with ISTEXT. If you still have the original what do you see for Format, cells, custom and what do you have for =ISTEXT(A1) if A1 is the cell. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Timmy" wrote in message ... Did this not help me. "Peo Sjoblom" wrote: Do formatcellsnumber and select 2 decimal number Regards, Peo Sjoblom "Timmy" wrote: Hi: Whenever I am typing any number in excel such as 14.00. Its putting double spaces between 14.00 (e.g., 14. 00). How can I correct this. |
#7
|
|||
|
|||
"Timmy" skrev i melding
... It doe not matter what language I am speaking. Bottom line is that when I am typing the numbers, place a period, and hit next number, it automatically puts two spaces. We can't help you as long as you refuse to cooperate. Best wishes Harald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
How can I convert binary numbers to decimal when they are larger . | Excel Worksheet Functions | |||
Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
sorting numbers more than one decimal | Excel Worksheet Functions | |||
How do I sum hours in Excel and convert to decimal numbers? | Excel Discussion (Misc queries) |