cell type in Excel

cell type in Excel

Anonymous
Not applicable
323 Views
1 Reply
Message 1 of 2

cell type in Excel

Anonymous
Not applicable
Hello,


Can you tell me, please how can I format as Text the data type for a column in Excel worksheet, which is opened from AutoCAD ( using VBA)?

Thank you!
0 Likes
324 Views
1 Reply
Reply (1)
Message 2 of 2

Anonymous
Not applicable
Put a single quote (apostrophe) at the beginning of the line. So if you sent to an Excel cell

1234, Excel would interpret this as a number and give the cell General formatting. General formatting will interpret this as an integer.

'1234, Excel will see this as a string.

You can tell if you have it right by the cell justification. If the cell has not been previously changed, that is, default formatting, text will justify to the left of the cell automatically, numbers on the right.
0 Likes