How to change . to , in a specific column??

**luckyali** · 07-02-2014, 10:49 AM

Dear experts,
I am using Excel 2010 German Version. for a given column i would like to change any "0.123" number to "0,123".
1. I tried the substitute formula, that works but i can not copy the value in the extra column to some other sheet as they are all formula based.
2. Also I Can't do Ctrl+H while in my document there are also dates like "01.01.2014" which will effect every thing. I just want to change it in a specific data column.

Thanks a lot in Advance
Ali

**pareshj** · 07-02-2014, 10:52 AM

Hi,

What you can do is select the specific column and then do replace all it will replace within that specific column. Please check this and hope this will help you.

Regards,
Paresh J

How to change . to , in a specific column??

LinkBack

Thread Tools

Rate This Thread

Display

How to change . to , in a specific column??

Re: How to change . to , in a specific column??

Thread Information

Users Browsing this Thread

Similar Threads

How to change . to , in a specific column??

Change detail in specific column

[SOLVED] If change in one column using specific word, then copy row to another tab, repeat.

check entire column on a specific value and change it

Change data based on specific column?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions