| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you find first 0 or first postive value in array | Excel Worksheet Functions | |||
| How do I adjust a formula a loan is displayed in a postive amount | Excel Discussion (Misc queries) | |||
| Showing Negative as Postive | Excel Discussion (Misc queries) | |||
| Automate bar chart color based on value postive or negative | Excel Discussion (Misc queries) | |||
| How do I change a large number of cells from a postive to a neget. | Excel Discussion (Misc queries) | |||
Linear Mode
