News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Format a column in Exc...

Finance | Project Operations, Human Resources, ...

Suggested answer

Format a column in Excel worksheet to Text

(0) Share

Report

Report

Posted on by Fredrik Brandt

15

Hi,
How can I format my Excel workbook to have the column as Text?

If I pass this field (defined as a string):

xlsWorkSheet.cells().item(1,4).value(custTable.VATNum);

It will be regarded as an integer.

I have in my field in column D a string (say "0001").

When Excel creates the column it interprets the string as number and removes the leading "000" and will convert it to integer.

I don't want that and the text should remain.

Can I use this below in some way?

xlsWorkSheet.cells().range('D:D').?

Any idéas?

Regards,

/Fredrik.

All responses Img

All responses (2)

Answers Img

Answers (0)

Fredrik Brandt 15 on at

Like (1)

Report

RE: Format a column in Excel worksheet to Text

Hi again,

I found it.

//Format column D to Text in the worksheet - @ means data stored in excel as string

xlsWorkSheet.cells().range('D:D').numberFormat('@');

Thanks.
Suggested answer

GirishS 27,816 Super User 2024 Season 1 on at

Like (0)

Report

RE: Format a column in Excel worksheet to Text

Hi Fredrik Brandt,

Check whether the below Microsoft documentation will help your scenario.

https://learn.microsoft.com/en-us/office/vba/api/excel.range.numberformat

Thanks,

Girish S.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2

Martin Dráb 230,458 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans