LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default In a formula, copy the value and formatting of another cell

Essentially, I want to date and timestamp an entry in a spreadsheet. So, I
want to copy the date and time from the @now() function as a value only.
That is, they won't change for a specific entry the next time I use the
spreadsheeet and make an entry.
 
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
Copy data to new cell but with different formatting chiefwidmer Excel Discussion (Misc queries) 3 April 12th 07 10:09 PM
copy/paste want to retain cell coloration but lose the conditional formatting source data Keith R Excel Discussion (Misc queries) 6 March 5th 07 09:10 PM
copy conditional formatting with 'unique' cell references Sam Excel Discussion (Misc queries) 1 October 18th 06 10:33 PM
How do I copy text formatting using a formula? topsquark Excel Discussion (Misc queries) 2 October 11th 05 02:41 PM
How do I copy formatting in a cell reference san jose native Excel Discussion (Misc queries) 1 June 30th 05 06:40 AM


All times are GMT +1. The time now is 05:06 PM.

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

About Us

"It's about Microsoft Excel"