Roman Numerals Won't Work With Join/Transpose

anwaee2

Board Regular
Joined
Sep 13, 2012
Messages
127
Office Version
  1. 2011
Platform
  1. MacOS
Again I have to rely on this forum for I am stumped. I have a column with Roman numerals created with the "Roman" worksheet formula. When I run my macro, it works but all the numbers come up as zeros. If I type the Roman numeral in the cells manually, it will work with the join/transpose formula combination perfectly. Is there a way around not having to manually type in each Roman numeral number. I have tried both worksheet formulas and VBA code to no avail. Has anyone else ran up against this and if so is there a fix for this. Thanks again to all the help I have received in the past.
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
can you post something from htmlmaker or similar so we can see what you have and the code supporting
 

anwaee2

Board Regular
Joined
Sep 13, 2012
Messages
127
Office Version
  1. 2011
Platform
  1. MacOS
Sorry for not getting back sooner. Gone for the holidays. Thanks for getting back. Join/transpose doesn't seem to work with formulas or maybe the formatting of Roman Numerals. I ended up using a helper column with the formula "=Roman(**) and then I did a copy/paste special using xlPasteValues and now it works fine. Thanks again for getting back and for all the other help I have received in the past.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,632
Messages
5,597,287
Members
414,134
Latest member
Tiyas44

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top