Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Cell Type From Word Macro
Hi,
I'm writing a macro in Word that copies some data over from Word and puts it into an Excel spreadsheet. My question is, how do you define the type (e.g. text/number/date etc) of a cell in Excel. I have some values with an undefined number of leading zeros so would like to define them as text instead. Many thanks, Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Cell Type From Word Macro
You could concatenate an apostrophe as a prefix character to the values with
leading zeroes to convert them to text. -- Kevin Backmann "IWT" wrote: Hi, I'm writing a macro in Word that copies some data over from Word and puts it into an Excel spreadsheet. My question is, how do you define the type (e.g. text/number/date etc) of a cell in Excel. I have some values with an undefined number of leading zeros so would like to define them as text instead. Many thanks, Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula setting cell type to blank and conditional formatting | Excel Worksheet Functions | |||
Trying to change the background of a cell if I type a certain word | New Users to Excel | |||
Trying to change the background of a cell if I type a certain word | Excel Discussion (Misc queries) | |||
I type a word in a cell, tab out and it changes | New Users to Excel | |||
I want to type the letter Y in a cell and have the word Yes appea. | New Users to Excel |