Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell format to remove decimal and keep zeroes
I need to create a check register in excel that will ultimately be converted to a space delimited file and cannot contain zeroes. For the check values, I have created a custom format for 12 characters without a decimal place. Once I do that, a check for $1,200.00 becomes 1200, and a check for 1201.10 becomes 12011. The $1,200.00 check as 1200 is picked up by the bank as 12.00 and the 1201.10 becomes 120.11 when you add the assumed decimal back. How do I remove the decimal place but keep the zeros?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format to remove decimal and keep zeroes
On Wed, 13 Aug 2014 17:04:17 +0100, MaryLovesExcel wrote:
I need to create a check register in excel that will ultimately be converted to a space delimited file and cannot contain zeroes. For the check values, I have created a custom format for 12 characters without a decimal place. Once I do that, a check for $1,200.00 becomes 1200, and a check for 1201.10 becomes 12011. The $1,200.00 check as 1200 is picked up by the bank as 12.00 and the 1201.10 becomes 120.11 when you add the assumed decimal back. How do I remove the decimal place but keep the zeros? Multiply by 100 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove preceding zeroes? | Excel Discussion (Misc queries) | |||
How to retain decimal zeroes? | Excel Discussion (Misc queries) | |||
I need to remove the zeroes in a chart | Excel Discussion (Misc queries) | |||
function or format - remove decimal but retain value | Excel Programming | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |