Format number column issue

[controlqueen]

Format number column issue<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I use various mfg part# spread sheets I reconfigure to upload to my website.
The columns I basically use are Pt#, description, price. Their sheets are usually sent to me with embedded formulas or things I am not aware of (my knowledge of excel is limited) which leads to various problems when I upload to my site.
<o></o>

1st problem: on a price column I only want it to extend .00 past the dollar. I format the cell column that way –it displays correctly in the column but in the fx bar is still showing .00000 how do I fix this fx to show .00 same as the format? <o></o>
<o></o>

2<SUP>nd</SUP> question: is there any good way to get rid of embedded formulas / clean up excel sheets before I use them.<o></o>

 

[VoG]

For the first you could use Tools > Options, Calculation tab and select Precision as Displayed.

For the second, select all the cells and copy them then Edit > Paste > Paste Special, tick Values and click OK.

 

[mahesh8498]

Try This.

Right Click, Select Format Cells, Under Number Tab you will find Text Option, Select text option. Now it will shows you in fx bar whatever u will tpe in cell.

 

[mikerickson]

2nd question: Select all the cells in a sheet. Copy. PasteSpecial Values. formulas are now values.

1st question: That's the way that formatting is supposed to work. Applying a 2 digit format does not change the underlying value (that Excel uses for calculation in formulas) (e.g. 23.34386), it only changes what the user sees. (23.34).

To change the underlying value in A1, put this formula in another cell =ROUND(A1,2).

 

[controlqueen]

Worked like a charm.
Thanks!
;@)