Excel Macro Divide numerical data

Stefan_28

New member
Joined
Oct 17, 2018
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2018
Hi,

I have an excel sheet with lots of data from column A till U. These contain various numerical numbers but some are of type General and some of type Numbers. Is it possible to create a macro which selects the whole sheet and divide the Number type only by 1000? I want to create this macro because I want to use this macro for various excel sheets
 
Last edited by a moderator:
CROSS POST

This question has been posted in at least one other forum.
Do not post any further responses in this thread until a link has been provided to these cross posts.

Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why: https://www.excelguru.ca/content.php?184

This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. It’s never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.
Please update your original post to include the link(s).
 
Back
Top