Hey,
I am working in an excel sheet. In a row are 100's of values.
I want to change . to ,
So, I have for example the number 1.25 and I want to change it into 1,25.
Manually is too much work.
Thank's in advance.
Hey,
I am working in an excel sheet. In a row are 100's of values.
I want to change . to ,
So, I have for example the number 1.25 and I want to change it into 1,25.
Manually is too much work.
Thank's in advance.
Try Find/Replace:
Find what: .
Replace with: ,
Replace All
Note that this makes the entries Text, and not available for calculations. Is this what you want? If you are looking to change the decimal to a comma for regional compliance, you need to adjust your settings in Windows>Settings>Regional and Language>Regional Options and pick the country you want to match. Click Apply.
Good Luck
Bruce
Last edited by swatsp0p; 09-13-2005 at 10:49 AM.
Bruce
The older I get, the better I used to be.
USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks