View original (French)

#

puceron37 Posted messages 2 Registration date   Status Member Last intervention   -  
puceron37 Posted messages 2 Registration date   Status Member Last intervention   -
Hello,

I created a table in Excel and in some of my columns, certain numbers have been replaced by #. When I re-enter the numbers in the cell, as soon as I exit, the # come back. These are monetary columns with ,.

As a result, it shows #value# in the total sum of my amounts excluding tax at the bottom of the table.

What should I do to solve this problem? When my cursor is just below the affected cells, the amounts I typed appear.

Thank you in advance.

2 answers

  1. Tubeyook
     
    Good evening,

    Have you tried changing the format of your cells (right click / cell format) and setting them to number?
    2