Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing dots with commas using macro
Hi, I have a problem and maybe somebody can give me some good advice. The problem is that I need to replace delimiter dots with commas, otherwise numbers will be handeled as text. When I simply use Replace function from Edit menu, it work perfectly - dots will be replaced with commas and text will be converted to numbers. I tried to record this function as a macro, but it doesn't work in macros. It replaces dots with commas, but text won't be converted to numbers and I can't use them in functions as SUM etc. Its strange because it works when done manually but doesn't work in recorded macro. How can I fix that? Thank you! -- maxest ------------------------------------------------------------------------ maxest's Profile: http://www.excelforum.com/member.php...o&userid=30143 View this thread: http://www.excelforum.com/showthread...hreadid=498282 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combobox changes the decimal commas to dots - How to prevent it? | Excel Discussion (Misc queries) | |||
Change dots to commas!! | Excel Discussion (Misc queries) | |||
Replacing commas with carriage return | Excel Worksheet Functions | |||
Change Dots into Commas as Decimal Divider | Excel Discussion (Misc queries) | |||
Replacing Tab with commas | Excel Programming |