Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet that was sent to me and the "wage" amount does not have
decimals included. I want to add a decimal to all of the wages, but not for sure how to do that without having to do each one separtely. Can this be done? Also, when I enter a decimal the number rounds up. Say, the number in the cell is 13525869 and I want it to read 135258.69. But when the decimal is entered but then it shows up as 135258.71 when I hit enter. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditionally formatting currency | Excel Worksheet Functions | |||
conditional formatting for currency | Excel Worksheet Functions | |||
Currency Formatting | Excel Discussion (Misc queries) | |||
Currency Formatting. | Excel Discussion (Misc queries) | |||
Currency Formatting | Excel Discussion (Misc queries) |