QUick Qn:whats the shortcut key to change numbers to date?

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

sokevin

whats the shortcut key to change numbers to date?

furthermore, whats the shortcut key to bring up the "format cells
dialog box?


thanks in advance :
 
what i want to do is convert a number like 38062 to a date format...
there is no direct shortcut for this?

i thought there was but i can remember... :(
 
Hi
you may record a macro that sets the format of a cell to a date format
and assign a shortcut for this macro
 
As Farnk has said, I think you wil need a macro. I'm not sure that there
is a shortcut key to format a serial value as a date. Pop this code into
a module via Alt+F11 Insert>Module

Sub FormatDate()
Selection.NumberFormat = "dd/mm/yyy"
End Sub

Change "dd/mm/yyy" to suit. Push Alt+Q then Alt+F8 select "FormatDate"
and click Option to assign a shortcut key.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
I don't think you really need a macro,
simply format the column with the date format you want.

However there is one shortcut to apply a specific date format to a cell
Ctrl+Shift+# Apply the Date format with the day, month, and year
i.e. 14-Nov-01 which does not have 4 digit year (2001-11-14) and not for the US.
so I'd think it unsuitable everywhere unless you like two digit years.

Shortcut keys
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
 
sokevin said:
what i want to do is convert a number like 38062 to a date format...
there is no direct shortcut for this?

i thought there was but i can remember... :(
Click to expand...

Next time you do it manually, record a Macro and set a shortcut key,
then you'll never have to do it by hand again! You might need to tweak
the VBA to make a generic function.

Mark.


Any questions? Ask Cupid!
http://www.askcupid.net
 
Back
Top