LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help on a function with Conditional Formatting nemadrias Excel Worksheet Functions 1 August 10th 06 08:55 PM
lookup function formatting Ben Excel Discussion (Misc queries) 1 July 6th 06 08:42 PM
Formatting from a Function VALid Excel Discussion (Misc queries) 3 January 2nd 06 03:27 PM
Formatting within function/equations jomurf Excel Discussion (Misc queries) 1 March 30th 05 07:22 PM
Conditional Formatting "OR" function Baz Masterson Excel Worksheet Functions 5 November 13th 04 04:20 PM


All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"