how to show data in excel exactly like in database?

bangswit

hi all I have data like this in my dimension 1
+03.00
+01.50
-03.75

something like that
but while i exported to excel, it become like these :
-3
1.5
-3.75

how to show exactly like i key in ??
like these
+03.00
+01.50
-03.75

SteveKnott

How are you exporting to Excel ?

You generally need to format columns as text before pasting, or Excel thinks those are numbers in Excel.

You can try putting a single quote in front of the values before exporting... i.e. if you are using Excel Buffer.

Define a Text Constant called SQ with a value of '

The instead of writing the field out, you write out SQ + txtValue

Bear in mind that you should only do this on non numeric columns or excel won't sum the columns.

Let me know if you need more info ?

DenSter

Selection.NumberFormat = '@';