Hello all I need to know how to create a format that would make a number XXXXXX, into XXXXXX0000. Adding zeroes to the back end instead of the front end. Any ideas? Please let me know.
Thanks,
Bob
Hello all I need to know how to create a format that would make a number XXXXXX, into XXXXXX0000. Adding zeroes to the back end instead of the front end. Any ideas? Please let me know.
Thanks,
Bob
Can't you just multiply the number by 10000?
Steve
"robertjtucker" <[email protected]>
wrote in message
news:[email protected]...
>
> Hello all I need to know how to create a format that would make a number
> XXXXXX, into XXXXXX0000. Adding zeroes to the back end instead of the
> front end. Any ideas? Please let me know.
> Thanks,
> Bob
>
>
> --
> robertjtucker
> ------------------------------------------------------------------------
> robertjtucker's Profile:
http://www.excelforum.com/member.php...o&userid=21805
> View this thread: http://www.excelforum.com/showthread...hreadid=499446
>
Without knowing the details, it's hard to say if this is a good option, but a format of general"00000" will display a handful of 0's to the right of whatever is in the cell without changing the value stored in the cell.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks