I WOULD LIKE TO CHANGE "." FOR "," IN EXEL FILE, CAN YOU HELP ME?

  • Thread starter Thread starter Question for excel file
  • Start date Start date
Q

Question for excel file

I am searching any formule or option to change "." for ",". I have receive a
document which show the decimals as "." and I need to change to "," to can to
add.
 
Are there any dots in there that are not decimal points (for example, in
abbreviations such as Mr., Co., etc.)? Also, where do you want this change
to happen at? That is, have you loaded the file and want to change it within
the worksheet(s); or do you want the file itself changed?

Rick


"Question for excel file" <Question for excel
(e-mail address removed)> wrote in message
news:[email protected]...
 
Tools>Options>International.

Change the separator characters.


Gord Dibben MS Excel MVP

On Tue, 25 Mar 2008 12:31:06 -0700, Question for excel file <Question for excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you remove excess decimal places in Excel? 4
Open Worksheet with exel file 2
how can I set up a backdrop in Exel? 1
exel files are not opening? 1
Adobe Acrobat and Exel 1
Change Default Save As for Single worksheet 1
I need to download an exel spreadsheet file. (file extension :xls) 2
How do I auto format data so that the middle letter changes. EG 2. 3

Back
Top