Excel Questions

[Tony Baloney]

Chaps,

How do I format cells to report data to a given number of significant figures?

The user will input data into unprotected cells and the results of the formula will be reported in protected cells i.e. 6 significant figures in the results cells. At the minute trailing zeroes are being dropped from my results.

[seafoid]

anyone know if its possible to change a column of negitive numbers (about 800 numbers)  into positive numbers? while i'm at it, is it possible to insert a blank line between each number (ie every other row is blank), is there any way of doing this without doing it line by line? thx for any help...

do you work for AIB?

[Hardy]

Chaps,

How do I format cells to report data to a given number of significant figures?

The user will input data into unprotected cells and the results of the formula will be reported in protected cells i.e. 6 significant figures in the results cells. At the minute trailing zeroes are being dropped from my results.

Format - Cells - Number - Number - Decimal Places

[Tony Baloney]

Chaps,

How do I format cells to report data to a given number of significant figures?

The user will input data into unprotected cells and the results of the formula will be reported in protected cells i.e. 6 significant figures in the results cells. At the minute trailing zeroes are being dropped from my results.

Format - Cells - Number - Number - Decimal Places

Not as simple as that. The piece I neglected to mention is that the number of decimal places will vary depending on the input data i.e. if I put 0.455410 in cell A1 I need that to dynamically carry through into various other cells. However on occasion someone may need to enter 0.455 into that cell.

What I'm really looking at is something "where number of signficant figures in A1 = 2, 3, 4, 5, or 6 then number of signficant figures in B1, C1... etc. must equal 2, 3, 4, 5 or 6"

[thebigfella]

Chaps,

How do I format cells to report data to a given number of significant figures?

The user will input data into unprotected cells and the results of the formula will be reported in protected cells i.e. 6 significant figures in the results cells. At the minute trailing zeroes are being dropped from my results.

Format - Cells - Number - Number - Decimal Places

Not as simple as that. The piece I neglected to mention is that the number of decimal places will vary depending on the input data i.e. if I put 0.455410 in cell A1 I need that to dynamically carry through into various other cells. However on occasion someone may need to enter 0.455 into that cell.

What I'm really looking at is something "where number of signficant figures in A1 = 2, 3, 4, 5, or 6 then number of signficant figures in B1, C1... etc. must equal 2, 3, 4, 5 or 6"

why not just format all cells (A1, B1, C1 ......) to 6 decimal places? then it's enforced throughout your worksheet/book?

[Tony Baloney]

Chaps,

How do I format cells to report data to a given number of significant figures?

The user will input data into unprotected cells and the results of the formula will be reported in protected cells i.e. 6 significant figures in the results cells. At the minute trailing zeroes are being dropped from my results.

Format - Cells - Number - Number - Decimal Places

Not as simple as that. The piece I neglected to mention is that the number of decimal places will vary depending on the input data i.e. if I put 0.455410 in cell A1 I need that to dynamically carry through into various other cells. However on occasion someone may need to enter 0.455 into that cell.

What I'm really looking at is something "where number of signficant figures in A1 = 2, 3, 4, 5, or 6 then number of signficant figures in B1, C1... etc. must equal 2, 3, 4, 5 or 6"

why not just format all cells (A1, B1, C1 ......) to 6 decimal places? then it's enforced throughout your worksheet/book?

I'm not explaining myself very well. I want it to be dynamic not static number of sig figs. If someone inputs data to 3 or 4 or 5 or 6 sig figs I want the other linked, protected cells displaying the results to report the results to the same number of sig figs. Would a length formula work?

[Hardy]

If I'm understanding you correctly, the format Number-General should do that - preserve whatever number of decimal places you enter.

[magickingdom]

anyone know if its possible to change a column of negitive numbers (about 800 numbers)  into positive numbers? while i'm at it, is it possible to insert a blank line between each number (ie every other row is blank), is there any way of doing this without doing it line by line? thx for any help...

do you work for AIB?

you could say that with the size of a mortgage i have with them   

[passedit]

If I'm understanding you correctly, the format Number-General should do that - preserve whatever number of decimal places you enter.

except that he wants to carry trailing zeroes???

[Doogie Browser]

if you are doing a spreadsheet and you have a column with current values and you need to create a new column with for example 10% added BUT when the new 10% extra column is created I want to delete the current price.  However when I do this the new field created goes back to zero

[Hardy]

Copy and paste the new column as values, rather than formulas, before deleting the original price column.

Copy
Paste Special
Values

[Hardy]

Chaps,

How do I format cells to report data to a given number of significant figures?

The user will input data into unprotected cells and the results of the formula will be reported in protected cells i.e. 6 significant figures in the results cells. At the minute trailing zeroes are being dropped from my results.

Format - Cells - Number - Number - Decimal Places

Not as simple as that. The piece I neglected to mention is that the number of decimal places will vary depending on the input data i.e. if I put 0.455410 in cell A1 I need that to dynamically carry through into various other cells. However on occasion someone may need to enter 0.455 into that cell.

What I'm really looking at is something "where number of signficant figures in A1 = 2, 3, 4, 5, or 6 then number of signficant figures in B1, C1... etc. must equal 2, 3, 4, 5 or 6"

why not just format all cells (A1, B1, C1 ......) to 6 decimal places? then it's enforced throughout your worksheet/book?

I'm not explaining myself very well. I want it to be dynamic not static number of sig figs. If someone inputs data to 3 or 4 or 5 or 6 sig figs I want the other linked, protected cells displaying the results to report the results to the same number of sig figs. Would a length formula work?

Tony, did you get sorted out with that?

If the Number-General format is not what you're after, the only way I can think of to do it is convert the number to text and parse the text by the position of the decimal point. Of course, then you're left with text. If you need to convert it back to numbers for calculations, then the formatting will be lost again.

[Doogie Browser]

Much obliged Hardy.

[Dougal]

im having trouble with decimal points,they keep coming up as euro signs,how can i change that?

[Mario]

im having trouble with decimal points,they keep coming up as euro signs,how can i change that?

Right click, format cells, change it to number as opposed to currency.