# TeeGrid DataFormat.Float has no effect

**URL:** <https://support.steema.com/t/teegrid-dataformat-float-has-no-effect/17892>\
**Category:** VCL / FMX\
**Created:** [December 19, 2025, 9:52am UTC](https://support.steema.com/t/teegrid-dataformat-float-has-no-effect/17892 "2025-12-19T09:52:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ujasper\_hsia01268](https://support.steema.com/letter_avatar_proxy/v4/letter/u/a87d85/32.png) [@ujasper\_hsia01268](https://support.steema.com/u/ujasper_hsia01268)\
**Post date:** [December 19, 2025, 9:52am UTC](https://support.steema.com/t/teegrid-dataformat-float-has-no-effect/17892/1 "2025-12-19T09:52:23Z")

</div>

Hello,

I’m trying to format a currency column in TeeGrid, but the DataFormat.Float property seems to have no effect.

**Environment:**

- Delphi 10.3.3 / TeeGrid 1.19
- Database: SQL Server
- Field Type: Money (mapped to TBCDField)
- Column Name: ‘Amount’

**Code tested:**

```delphi
TeeGrid1.Columns['Amount'].DataFormat.Float := '0.';
TeeGrid1.Columns['Amount'].DataFormat.Float := '0.##';
TeeGrid1.Columns['Amount'].DataFormat.Float := '0.00';
TeeGrid1.Columns['Amount'].DataFormat.Float := '#,##0.0000';

```

[teeDataFormat.7z](https://support.steema.com/uploads/short-url/zkkmuvhKMfnT45noSUydgMCwfEm.7z) (51.6 KB)  
None of these format strings change the display format. The column still shows the default format.

**Question:**  
What is the correct way to format currency/money fields in TeeGrid? Should I use a different property or approach?

Thank you!

---

<div class="post-metadata">

**Author:** ![Marc](https://support.steema.com/user_avatar/support.steema.com/marc/32/7997_2.png) [@Marc](https://support.steema.com/u/Marc)\
**Post date:** [December 24, 2025, 12:37pm UTC](https://support.steema.com/t/teegrid-dataformat-float-has-no-effect/17892/2 "2025-12-24T12:37:40Z")

</div>

Hello,

Your approach appears correct. See the Cell Editors demo. (ie. TeeGrid-VCL-FMX-Samples/demos/VCL/Cell Editors  
/Unit\_Editors.pas).

```plaintext
// Set some column Formatting strings
TeeGrid1.Columns['Height'].DataFormat.Float:='0.##';
TeeGrid1.Columns['BirthDate'].DataFormat.DateTime:='mm-dd-yyyy';

```

That appears to be working correctly in the demo, so perhaps there is a different, underlying issue.

Regards,  
Marc Meumann
