How to format cell value view

Flo1 · 08-17-2021 02:37 AM

hi, is there a way to format the view of a value without change the cell value.

For example : in a row of my column [phone] i have this phone value : 0601010101
I would like that the user can see the number like that on view detail : 06 01 01 01 01
but I need to have only 10 numerics caracteres in this cell.

Aurelien

Hi @Flo

You may want to check this:

Flo1

thanks but my purpose is to find a way to show the value of a cell in a different way that the value is stored.
An other example : I have a date time value 17/08/2021 16:50 and I want to show only the date in the row detail but i need to keep the date time format in the column.

Aurelien

OK. Then, you can use a virtual column with this:

Marc_Dillon

Steve

In short, no.

VOLODYMYR_TYROL

It’s not the best idea but you can create a virtual column and use CONCATÉNATE() and MID () To assemble right version. For original column with phone number you can use Valid if: LEN([_ThisRow].[phone number])=10