Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Sheet problem

Former Member
499

Hi Frnds,

When I am Displaying Time field in excel sheet the format is changing the field reference I am using is TVRO-FAHZTD, i wnt to print time in HHHHH:MM format

Thanks,

Y.ravi kumar

Message was edited by:

ravi kumar

1 ACCEPTED SOLUTION

Former Member
43

Hi,

Declare the reference field as charachter you will get the correct output.

Before moving to the final internal table format your time according to your requirement using EDIT MASK.

Reward if helpful.

3 REPLIES 3

Former Member
44

Hi,

Declare the reference field as charachter you will get the correct output.

Before moving to the final internal table format your time according to your requirement using EDIT MASK.

Reward if helpful.

Former Member
43

Hi

When you send values to Excel, your excel settings changes the format.

So contatenate a ' (single colon) to the values you are sending, then Excel will consider it as string and it'll not change the format.

Regards

Surya.

Former Member
43

Hi,

This is depends on the Excel sheet format, please change the excel sheet format

Regards

Sudheer