Apply OS: Windows, Linux

Apply Navicat Product: All

Apply Navicat Version No.: Windows version 7.x or above, Linux version 8.x or above


With an opened table, right-click your chosen column and select Set Display Format or select Display > Set Display Format.

Here are some examples on setting display formats:

Origin

Format

Output

123456

### ###

123 456

123456

###.00

123456.00

123456

##.##

1234.56

Have more questions?
Submit Ticket