Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Omitting the whole number when formatting decimals
Hi,
I am trying to omit the whole number when it is copied into a new cell. Ex. 29.8765 = .8765 I do not want a leading 0 either or for the decimal to be rounded up or down, but copy exactly the last four digits behind and including the decimal point. I also would like to nest this formatting in a formula that combines copying the number from the old cell to the new and then automatically format. Any help would be appreciated. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Omitting whole numbers when formatting decimals | Excel Worksheet Functions | |||
Whole Number and Decimals | Excel Discussion (Misc queries) | |||
Formatting axis decimals | Charts and Charting in Excel | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Omitting Some Cells From Conditional Formatting | Excel Discussion (Misc queries) |