i can't get date serial # to show as date in formula

  • Thread starter Thread starter fergsnort
  • Start date Start date
F

fergsnort

I was trying to use a simple if/then statement that will return either
name or a date - but the date inevitably comes back as a serial number
I then found that no matter what formula i used, other than "=", th
date comes back as a serial number (cells are formatted to show a date

Example: Col. r contains dates, when i enter simply =r2 i get the dat
(not serial no.)
If i enter =a2&r2 i get a2 & serial no.
(concatenate ***THIS is what i need to do ultimately, concatenate
because i want the info from the a column and r columns to go thru to
text box that references that info
 
I think in a worksheet you should use TEXT() instead of
--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
FORMAT()
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

generate serial numbers and date it entered 3
The Serial # is showing and not the actual date 2
Date String To Serial 11
Date Difference Calculations 1
Date to TEXT. NOT to sequential serial number 2
Convert Date to Text 2
Disable auto (date) format? 3
Serial Dates 4

Back
Top