Word Macro to create Excel formatted cell
Closed
glowackt
Blocked Profile - Mar 25, 2014 at 03:48 PM
- Posts
- 1
- Registration date
- Tuesday March 25, 2014
- Status
- Member
- Last seen
- March 25, 2014
Blocked Profile - Mar 25, 2014 at 03:48 PM
Related:
- Word Macro to create Excel formatted cell
- Excel format cells if another cell contains text ✓ - Forum - Excel
- Excel format cells date - Guide
- Excel format cell if another cell contains ✓ - Forum - Excel
- Excel macro to create new sheet based on value in cells - Guide
- Excel macro to create new workbook based on value in cells ✓ - Forum - Excel
1 reply
Try converting them to text as in: =text(whateverthetextwouldbe)
The numbers are the number of days since 1/1/1900.
Are the fields in the database that the dates going into, formatted as a date, or text?
Why do you not convert the word document into a text file, and import the text file into the database, then it won't have all of the extra over head of excel formatting.
Just a thought. I used to have an admin that would print out an invoice to scan it back in, she didn't realize she could print to an image/file.
Let us now!
Have fun!
The numbers are the number of days since 1/1/1900.
Are the fields in the database that the dates going into, formatted as a date, or text?
Why do you not convert the word document into a text file, and import the text file into the database, then it won't have all of the extra over head of excel formatting.
Just a thought. I used to have an admin that would print out an invoice to scan it back in, she didn't realize she could print to an image/file.
Let us now!
Have fun!