If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel number format
People, here is the problem I am facing. my excel accepts both number in
"100.00" (hundred) format and "100,00" (hundred ) format. both of them are numbers in my excel. But when I perform my calucations using both formats it doesn't calculate anything. I don't like the 100,00 format. how canI get rid of them? my excell automatically converts all the 100.00 numbers into 100,00 numbers. Please help |
#2
|
|||
|
|||
Excel number format
Select the entire range and do right click and select format
cellsNumberCategoryNumber and give ok. Still If you see the comma (,) in the cells then select the range and press Cntrl+H and in Find What: type , (comma) and in Replace With type . (pull stop) and press Replace All. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Mibrayev" wrote: People, here is the problem I am facing. my excel accepts both number in "100.00" (hundred) format and "100,00" (hundred ) format. both of them are numbers in my excel. But when I perform my calucations using both formats it doesn't calculate anything. I don't like the 100,00 format. how canI get rid of them? my excell automatically converts all the 100.00 numbers into 100,00 numbers. Please help |
Thread Tools | |
Display Modes | |
|
|