I Need to change Date Format in BEx report

[ccc_ccc]

Hi Experts,

i Need display with required values with following symbols in BEx report # and Date format change as per client requirement. Without any VB Code.

Let me know solution for this.

By

ANR

[Former Member]

I would like to change the default value of the date from "#" to blank...Any suggestions....

[Former Member]

hi

check your windows or excel settings for changing the date format

Control Panel->Regional Options->Date->Short Date format.

[ccc_ccc]

My actual requirement,

by default date format display in BEx Reports MM/DD/YYYY fomat, but i want change DD/MM/YYYY format without using any VB macro and also instead of displaying "#" i need display "0" (Zero).

let me know the solution.

by

ANR

Anybody ....

Message was edited by: ANR

[former_member184494]

ANR,

You can set the date format under user creation and it will get applied.

However as for displaying the # the decison is yours to take regarding if you want to make the change global without any code or affect only the workbook ?

Arun

[edwin_harpino]

hi ANR,

do you mean system->profile->own data

tab 'defaults'->date format.

and windows regional setting ?

hope this helps.