shortcut ket to change formatting of text

  • Thread starter Thread starter sokevin
  • Start date Start date
S

sokevin

hey,

whats the shortcut key to change numbers to dates, and vice versa.

cheers :
 
Hi!
This may be the sort of thing you want:

CTRL+SHIFT+#
Apply the Date format with the day, month, and year.

This is a quote from Excel Help ( use "Keyboard shortcuts" for th
search)

Al
 
ctrl-1 will pop up the Format|cells dialog

ctrl-~ (ctrl-tilde, aka ctrl-shift-backquote on my USA Keyboard)
will format a cell as General

ctrl-# (ctrl-shift-4) will format as d-mmm-yy

Try searching excel's help for Shortcuts and you'll see lots more.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CTRL + ` 2
Cannot sort data 1
converting dates from file 3
Bold Font 2
Windows 10 How to create individual shortcut for each user 1
shortcut key to go to formula bar 2
Losing Formatting in 2003 to 2007 worksheets 3
when pressing forward slash key numbers appear below headings 2

Back
Top