Data format in single cell

[#1]

Hi there,

I have another question.

It it possible to change the data format of a single cell? I know that you can change the colour and borders via Design Grid but can I also change the number format for one cell?

E.g. I have a table where there are numbers in ###,#% and in #.### format but right now I can only choose #.### OR ###,#% but I would like to have both.

Hope you got what I'm looking for.

Thanks a lot!

[oxtontom]

Hi cdettmer,

I am fairly sure you can write the formatting in the expression / definition and then use an IF statement to toggle between the formatting. Though I am fairly new myself and not exactly sure of the code! my gues would be something like this

=If( Number() - Number1 < Number3

  , format ####

  , If( Today() - number 3 < number 2

      , format ######%

      , format ######,#

      )

  )

Hope this helps!

Tom

[#3]

Hi oxtontom,

with the expression "number" are you adressing a specific cell or do you want me to enter the number?

Thanks!!

[#4]

Well that is settled but QV doen't accept the term format. Does anyone knows the syntax?

Thanks!

[#5 · Accepted solution]

Ok I figured it out, that is the formula i'm using

=IF("expression">1,Num("expression",'#.###,#'),

("expression"<1,Num("expression",'###,#%'))