1 dp.xlsxAppreciate any help I can get on this
I have a cell say A1 that has 76.33333 showing in the Fx cell on input but in cell A1 I have rounded this to show as a round 76
however I want to send this out and dont really want the user to see/use 76.3333 on their systems
how do I make the actual cell show as 76.333 rather than 76
hope fully the attached demonstrates what im trying to see - this is a simple version but I do have a number of sheets and versions that need to be updated
thanks
If you don't want to work on this column, then you can choose from the format>protection>secret, for this column and then protect the whole sheet.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I' not entirely sure what your problem is here??? The fx value shows 76.3333 because that's what was entered. You have formatted the cell A1 to show no decimal places, hence the display of 76.
Is the actual value 76.3333 a calculated value in your 'real' spreadsheet? If so, you should enclose it in an INT function, which will do your rounding for you and show only the formula in the fx area (the formula bar).
hi bumpty, you can do a formula in another column & later paste over as values if needed. if you need to roundown, try:
=INT(A1)
to round depending on decimal:
=ROUND(A1,0)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Fortis hi
This is exacctly what I need - problem is I can not find the 'secret ' bit ?
im using Excel 2010 - are you able to advise on the steps I need to take
many thanks
I'll try..
Highlight column A
Right Click>>Format Cells>>Protection>>Check Secret>>OK.
Highlight All other columns of your sheet.
Righr Click>>Format Cells>>Protection>>UNcheck >Lock>>OK
Done.??
thank you i have tried the round function but the problem I have is that there are many many sheets and cells and I can not do an easy copy and paste within it and danger is the results may get currupted.
The sheet is being sent to a supplier that will use to upload into their pricing module - they see the price of 76 and need to import 76 and not 76.333 as it presently shows in the fx box
sorry to sound a little dim but not sure how to round withour copy and pasting and then copying back as a value - trying to avoid this if I can ?
And of course, then choose Protect sheet from the toolbar...Originally Posted by Fotis1991
Doc1.docx
i dont seem to have the secret !!
My poor English.......Sorry
Hidden. Not Secret..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks