I need to copy numbers and paste them with two different commands:
command1 copies number text in x,xxx,xxx.xx format and reformat as x.xxx.xxx,xx to paste
command2 copies number text in x.xxx.xxx,xx format and reformat as x,xxx,xxx.xx to paste (the reverse of command1)
I've been able to to do one format conversion with Cntr+C and applying triggers, but I could not see how to serarate formatting as I need above
Thanks for the help
No. I need two separate - exclusive- clipboard operations:
1) At certain times I need to copy numbers in BRA format (that have dots as thousands separators and commas as decimal separators) and paste the copied numbers in US format (delete dots and replace commas with dots)
2) At other times I need to copy numbers in US format (that have commas as thousands separators and dots as decimal separators) and paste the copied numbers in US format (delete commas and replace dots with commas)
As an exanple, I'd like to have two keyboard shortcuts (e.g. Cntr+Z and Cntr+Y)
I'd like to be able do two separate, exclusive things:
(a) select a certain text, then Cntr+Z would do 2 things: [1] delete all dots from the selected text [2] replace all commas in the selected text with dots
(b) select a certain text, then Cntr+Y would do 2 things: [1] delete all commas from the selected text [2] replace all dots in the selected text with commas
Create two macros to do job (1) command1 and job (2) command2. Then in settings you can assign a hot key combination to command1 and command2, for example the ones you mention ctrl-Z and ctrl-Y.
See attached the macros that probably will do the job.
First ctrl-c what you want to have for the job and then use your hot key combination.
After that you can ctrl-V to get the result.
Hi C# Clouseau, thank you for your input! I've tried to download the macros you attached, but it seems they are protected and I'm not able to download them - if they are not long, could you display them here?
Again, thank you.
Quote:
See attached the macros that probably will do the job.
First ctrl-c what you want to have for the job and then use your hot key combination.
After that you can ctrl-V to get the result.
And you could try to combine the two in one macro only.
Then you have to look into the items you have copied to identify ehat shoud be done.
A format like this ,xx should trigger the comma decimal to point decimal, and .xx to comma.
But I do not know yours, could be ,xxxxxxx or ?,x
The problem with two macros is that you have to decide which macro to run. And if you run it on a wrong format it will change definitely something that is . or ,
,xx should trigger the comma decimal to point decimal, and 
