View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dim dim is offline
external usenet poster
 
Posts: 123
Default Formatting the =NOW() function ?

Hi,
Im using the =NOW() function to display time and date in my worksheet.

Could someone please tell me a few ways to format it to display differently?
e.g: Date only, time only, date first, time first etc

Thankyou if you can help.