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

bash enquiry

Q: bash command that'll remove all empty folders in the present directory A: find . -type d -empty -delete find finds, . specifies the present folder, -type d specifies directories (to avoid deleting empty files), -empty specifies empty, -delete instructs to delete. duh.
Read more

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

ghostscript

When concatenating PDFs into a single file, I tried imagemagick: convert first.pdf second.pdf third.pdf output.pdf but the resolution suffered. This forum suggests that Imagemagick makes use of ghostscript in this action and provides a command that cuts out the middleman: gs -dBATCH -dNOPAUSE -q -sDEVICE=pdfwrite -sOutputFile=temp.pdf pdf1.pdf pdf2.pdf This worked like a charm, and fast, but I'm not massively happy copypasting commands I'll never remember. 1) record it here for future use 2) alias it, or write a super simple bash script? 3) look into ghostscript and see if I can simplify the command, learn the syntax
Read more