Thank you so much, I'll try it right now!!

Regards

Diane

"Gary''s Student" wrote:

Not a silly question at all:


Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To use the macro from the normal Excel window:

1. ALT-F8
2. Select the macro
3. Touch Run



To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

For this macro:
1. install the macro
2. select an area to convert
3. run the macro


Update the post if you have any problems
--
Gary''s Student - gsnu200792


"DianeG" wrote:

Thanks for the response , I'm probably going to ask a very silly question
now, but as I don't use VBA, where do I type this in?

Regards

Diane

"Gary''s Student" wrote:

If you have data that looks like:
12,34
and want to convert it into:
12.34

Then select the cells in question and run:

Sub commaconverter()
Set r = ActiveSheet.UsedRange.SpecialCells(xlCellTypeConst ants)
Set rr = Intersect(Selection, r)
comma = ","
dot = "."
For Each cel In rr
cel.Value = Replace(cel.Value, comma, dot)
Next
End Sub

--
Gary''s Student - gsnu200792


"DianeG" wrote:

Hi

A client of mine works in the UK but deals with Austrian colleagues who use
a comma instead of decimal point in their calulations. When he receives the
spreadsheets he can't calculate in them. I was thinking around the lines of
using find and replace to swap the commas but I wondered if anybody else had
a more efficient way of doing it

Thanks in advance

Diane