String Maniplation and Date formula

[Bruce Roberson]

+"Estimated as of : "&@STRING(@MONTH(@NOW),0)&"/"&@STRING(@DAY(@NOW),0)&"/"&@STRING(@YEAR(@NOW)+1900,0)

Excel is having a hissy fit with my attempt to convert this QPW string formula to a suitable Excel substitute. I know to substitue fixed for @string. But things like @month@now to me ought to be easy to say month(now), and @Day(@now) ought to translate to day(now), but none of this seems to be helping.

The net result of the above formula should read as follows: Estimated as of 7/20/03, and the date should of course change as the date changes.

 

[Bruce Roberson]

Very timely answer, and the solution is concise also.

Thanks again,


Bruce

 

[Bob Phillips]

Relax Eric.

I was just trying to add to your post to assist Bruce should he undoubtedly
have a need in the future. As Bruce said, your answer suited well, but there
is always room for some more.

Bob

 

[Bob Phillips]

Bruce,

It sounds to me that you have somehow merged cells D to N.

Go to menu Format>Cells, and select the Alignment tab. If the 'Merge cells
box at the bottom is checked, uncheck it.