Change date to text

  • Thread starter Thread starter JeffH
  • Start date Start date
J

JeffH

On the top of a spread sheet the operator types in the
date and it shows up as 6/30/04. There many more places
on the spreadsheet that the date is changed by hand to
the following: 063004invm, 063004invw, etc...

I would like it to automatically use the date she types
in to fill in the other cells with the date.

I know it can be done. I just don't know how.


Thanks!!!
 
-----Original Message-----
On the top of a spread sheet the operator types in the
date and it shows up as 6/30/04. There many more places
on the spreadsheet that the date is changed by hand to
the following: 063004invm, 063004invw, etc...
Click to expand...

If the date is in cell A1, here is an example ...

=TEXT(A1,"mmddyy") & "abcd"

Try it and see if it works!

Blessings in abundance, all the best, and ENJOY!

Art Carlisle, PA USA
 
Jeff

2 ways:

1.- Simply call the date cell from all the cells where you
have the other format =A1 (or were ever original date is
input) and Custom Format mmddyy"invm", mmddyy"invw", etc

2.- Use this formula:

=TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00")&RIGHT(YEAR(A1),2)
&"invw"

Cheers
Juan
 
...
...
2.- Use this formula:

=TEXT(MONTH(A1),"00")&TEXT(DAY(A1),"00")&RIGHT(YEAR(A1),2)
&"invw"
Click to expand...
...

Why would anyone in his/her right mind use the formula above rather than

=TEXT(A1,"mmddyy""invw""")

?!
 
Back
Top