excel current date

https://exceljet.net/keyboard-shortcuts/insert-current-date

CTRL + ;

when recording a macro, this action will be interpreted as insert "11/05/2016" say - rather than "insert current date"

you need

= Date

instead

Comments

Post a Comment

Popular posts from this blog

no sound in Papers Please

No sound at all, actually. First I installed alsa-utils, checked alsamixer master was not muted. Installed pulseaudio and pavucontrol. This gave me sound on youtube but not the game. Eventually found this tip in the hotline miami AUR comments: On x86_64 I had to install lib32-libpulse to get sound working. Without the package there was that error: ALSA lib dlmisc.c:252:(snd1_dlobj_cache_get) Cannot open shared library /usr/lib32/alsa-lib/libasound_module_pcm_pulse.so AL lib: (EE) alsa_open_playback: Could not open playback device 'default': No such device or address   https://wiki.archlinux.org/index.php/Advanced_Linux_Sound_Architecture#Unmuting_the_channels https://aur.archlinux.org/packages/hotlinemiami/
Read more

pdf to png/jpg/etc

Not often I learn something at work that I need to put on here. Anyway, imagemagick: convert -density 600 input_file.pdf output_file.png Gives me a lovely hi-def version of the image. Too hi, probs, but at least it's relatively easy to resize (down) once it's in the appropriate image format.
Read more

To Do

I enjoyed that little foray into problem-solving for Mint on the probook, and I learned some good stuff in the process. My C++ self-tutelage is stalling because it's just getting more and more abstract and I don't have any proper examples to work with. So it'd be nice to come up with some stuff to do on the linux system using bash or whatever. I'm going to put some ideas down here to investigate. * Cron jobs. I've been meaning to get around to this. The 1st idea I have is to take the items in my monthly folder and archive them. Or label them with tags. Or something like that. And start a new folder each new month? * Automate my photo process flow. Script that takes the contents of my camera's SD card and treats them how I want to enable uploads to flickr,  backup to the external HDD. Add tags? * Use scripted imagemagick actions to take all photos in my monthly folder, convert them to an appropriate size and resolution, then animate them into a
Read more