ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   POSTIVE PAY FILE FORMAT (https://www.excelbanter.com/excel-worksheet-functions/195796-postive-pay-file-format.html)

Melissa

POSTIVE PAY FILE FORMAT
 
I AM TRYING TO "RIGHT-JUSTIFY,ZERO-FILL, NO DECIMAL" - 10 SPACES

EX. 200.00 NEEDS TO BE 0000020000

PLEASE HELP

John C[_2_]

POSTIVE PAY FILE FORMAT
 
See my response to your same question from yesterday. Please avoid double
posting.
--
John C


"Melissa" wrote:

I AM TRYING TO "RIGHT-JUSTIFY,ZERO-FILL, NO DECIMAL" - 10 SPACES

EX. 200.00 NEEDS TO BE 0000020000

PLEASE HELP


Mike H

POSTIVE PAY FILE FORMAT
 
Melissa,

Turn the Caps lock off it's difficult to read.

A custom format of 0000000000 (thats's 10 zeroes) would probably do what you
want but this would round anyting with a decimal to the nearest integer.

Mike

"Melissa" wrote:

I AM TRYING TO "RIGHT-JUSTIFY,ZERO-FILL, NO DECIMAL" - 10 SPACES

EX. 200.00 NEEDS TO BE 0000020000

PLEASE HELP


Melissa

POSTIVE PAY FILE FORMAT
 
John, I'm sorry I'm new to this and I was not notified of a response
yesterday and can not find the question?? How do I find it? Thank you
"John C" wrote:

See my response to your same question from yesterday. Please avoid double
posting.
--
John C


"Melissa" wrote:

I AM TRYING TO "RIGHT-JUSTIFY,ZERO-FILL, NO DECIMAL" - 10 SPACES

EX. 200.00 NEEDS TO BE 0000020000

PLEASE HELP


John C[_2_]

POSTIVE PAY FILE FORMAT
 
If you actually click on your name, it should bring up a little box, and then
there is a link that shows Recent posts by this user in the top right corner
of the box.
--
John C


"Melissa" wrote:

John, I'm sorry I'm new to this and I was not notified of a response
yesterday and can not find the question?? How do I find it? Thank you
"John C" wrote:

See my response to your same question from yesterday. Please avoid double
posting.
--
John C


"Melissa" wrote:

I AM TRYING TO "RIGHT-JUSTIFY,ZERO-FILL, NO DECIMAL" - 10 SPACES

EX. 200.00 NEEDS TO BE 0000020000

PLEASE HELP



All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com