Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Replacing a date in date format.

Hi Bart

I only want to change dates in table headers. It would be difficult to do it
the way you have suggested.

Thx

Oz


On 12/7/07 15:03, in article
, "Bart"
wrote:

I played with the Find & Replace functions. Couldn't get it to work.
Are those dates particular dates or do you want to change all dates.
Because you could add 61 days like:

B1: "=A1 + 61"

where A1 is the cell with the date to be changed. ('B1:' is de target
cell)

Bart


Reply
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
permanent conversion of 1904 date format to 1900 date format Jos Excel Worksheet Functions 4 November 26th 15 02:48 PM
convert serial date format to normal date format Flagworld Excel Discussion (Misc queries) 3 September 23rd 08 01:32 PM
Peculiar date format behavior when replacing parts of date Henrik Excel Discussion (Misc queries) 1 March 15th 07 10:58 PM
code to convert date from TEXT format (03-02) to DATE format (200203) Gauthier[_2_] Excel Programming 0 September 22nd 04 03:26 PM
Change a date in text format xx.xx.20xx to a recognised date format concatenator Excel Programming 1 November 24th 03 11:33 PM


All times are GMT +1. The time now is 05:23 AM.

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"