What's the most efficient way to disable saving of fields with commas in an entire Excel file? One approach could be to use Data Validation, and the other could be to validate all fields using a macro when the file is being saved. Are there other ways? Which one is better and why?
Subscribe to:
Post Comments (Atom)
-
I did some reaches, and I know "Desktop.ini" and "Thumbs.db" files are hidden files for view customizations, and I know ...
-
I am trying to understand why the OOM killer has reaped a process on a KVM virtual machine running with 1 gigabyte of memory. While I do alr...
-
I have a HP DL380p Gen8 server with ESXi 5.5 running on it and HP Smart Array P420i. I've installed 4 new hard disks on it and want to p...
-
I have (only) 512MB to spare. The only thing running on my VPS is PHP/MySQL and on top of it Wordpress. No mail server or any other applicat...
-
On RabbitMQ 3.5.7 Ubuntu 16.04. I want to implement RabbitMq Management plugin only on localhost, the idea is to use a tunnel to reach the R...
-
We rolled out this new Windows 8.1 machine on the domain recently, other desktops are still using XP. One of the software we install is the ...
-
What software would you recommend to monitor a network? We have a main server which acts as a DNS among other services. An...
No comments:
Post a Comment