 |  |  |  |  |  |  |  |
Excel cell references
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Thread Solved |
•
•
Join Date: Apr 2008
Posts: 58
Reputation: 
Solved Threads: 9
Junior Poster in Training
I am trying to keep formatting between cell references.
For instance, I have a date in once cell (J9) and would like to add this date to a text field so e.g.:
="This will take effect on " & J9 & "."
However, when I do this, I end up with numbers...
"This will take effect on 172543."
I have googled for quite a while now, and tried many built in functions, including left, right, concatenate, datevalue, etc. etc. etc. and cannot find a solution for how to do this in a cell formula.
Any ideas?
For instance, I have a date in once cell (J9) and would like to add this date to a text field so e.g.:
="This will take effect on " & J9 & "."
However, when I do this, I end up with numbers...
"This will take effect on 172543."
I have googled for quite a while now, and tried many built in functions, including left, right, concatenate, datevalue, etc. etc. etc. and cannot find a solution for how to do this in a cell formula.
Any ideas?
 |
Similar Threads
- Excel Question (Windows Software)
- Sports Team Statistics (MS Access and FileMaker Pro)
- Network Services/Support (Tech / IT Consultant Job Offers)
- Getting numbers out of Excel via VB6 (Visual Basic 4 / 5 / 6)
- Regular Expressions (C#)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Excel VBA or Lookup Help
- Next Thread: extract numbers from string
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
