How do you get 4.23 to change to 4.3? Shouldn't it display as 4.2?
Try =Roundup(a1,1) and make sure the cell is formatted cell, 1 decimal
"John Wirt" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> I want to link to a cell and have the number displayed be the value
> displayed that cell (as formatted), not the value stored in the cell.
>
> Example,
>
> value stored in A10 = 4.234098
>
> value displayed in A10 =4.3 (because formatted as number to 1 digit)
>
> cell C10 linked to A10 as '=A10
>
> I want the number displayed in C10 = 4.3, not 4.234098, without ANY
> formatting on A10
>
> One way to do this would be to link to A10 so that both the number AND the
> formatting on cell C10 to be displayed.
>
> John Wirt
>
>
>
>
|
Similar Threads
