showing .260 instead of .26
How do I show the zero in the thousandth postion in a decimal. I have the cell formatted as a number to show 3 decimal places. I am required to it as .260 not rounded off to .26. This is the answer to a calculation. the cell value is not always .260. many times it is 3 numbers in the decimal without a zero, ie. .123
Thank you
Last edited by jimb01; 08-19-2011 at 01:15 PM.
Are you sure it was entered as a number?
Select the cell and go to Data|Text to columns and just click Finish... does that change anything?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That didn't work. I basically don't want it to round off
Last edited by jimb01; 08-19-2011 at 01:57 PM.
If you formatted as Number with 3 decimals, then I can't think of anything else...
possibly post a sample workbook showing the issue?
Can it be stopped from round off the number?
Or is there a way to program it , That if the answer is only in the hundreths .26 to be able to add a zero .260 to make it look like thousandths?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks