Hi,
I am not sure if I can explain this correct. I have a column with all different dollar and cent amounts. I need to make my column eleven spaces wide. If my amount is $66.00 I need to add seven more # to make the column eleven spaces. Is there a formula I can use that will put enough # to make my column eleven characters wide. I would like to do the entire column at once. Am I asking for the impossible?
Are you talking about making this:
$60.00
Look like this?
$000000060.00
If so, that's a custom number format, highlight the column and press CTRL-1, then format:
Custom: $000000000.00
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
No what I need it to look like is #######66.00 or #####120.87 or ########1.45 it is for a bank upload.
Last edited by Tina Lower; 09-07-2010 at 09:57 PM.
So are you saying that the amounts literally need to be text strings with leading # signs so that the # signs and the numbers totals 12 digits (not counting the decimal)?
If so, try:
=REPT("#",12-LEN(TEXT(A1,"0.00")))&TEXT(A1,"0.00")
Fill that down as many rows as necessary. You can then copy these cells and use PasteSpecial -> Values on top of the original values.
Thank you Paul, I will try this and I will make another post if is does not work. I am sure I am not wording things right.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks