Hi, How i can fix in the cell so to type only numer like 00025 etc and to show up text Payment#00025 so I am trying to Format Cells so custom but I have issue on it.
Hi, How i can fix in the cell so to type only numer like 00025 etc and to show up text Payment#00025 so I am trying to Format Cells so custom but I have issue on it.
Last edited by bixha; 04-25-2024 at 03:36 PM.
I would expect a number format code like "Paymet#"00000. Recognize that the underlying cell value is still the number 25, but it will look like "Paymet#00025"
Originally Posted by shg
Beacue al the time i need to time payment diffrent number like Payment# 00251, next row Payment#00152 etc so I am looking is possibe to time onlye number like 00152 and to show up text Payment#00152 etc used Format Cells so custom Payment* but it not working
What are you using for the custom number format code? Did you try the number format code I proposed?
Like it "Paymet#00025" see excel how i have it
Are you talking about cells C14, C16, C18, etc.? I notice that they are currently formatted as General. If I apply a format like I proposed above ("Payment#"000000), I can enter 1761 into C14, and it will display as Payment#001761.
Is that what you are trying to do?
Yes is correct
Are you able to do the same? Format the cell with a custom format code of "Payment#"000000 and then enter 1761 and see the desired result?
Thank your assitence
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks