Make all numbers rounded and no decimals in entire workbook

[FLYFRG]

anyone know a macro to accomplish this? the problem is if you have dates in workpaper, it screws the dates up because they are recognized as numbers

any help appreciated

[nankw83]

Hi FLYFRG,

Try below code a copy of your file ...

Edit: The code will convert all rounded numbers without the formulas

Please Login or Register  to view this content.

[FLYFRG]

thanks- doesnt seem to be working for me

[nankw83]

Does it give any error ? Can you post a sample file to see what?s happening

[Sintek]

Please Login or Register  to view this content.

[FLYFRG]

where do i attach sample file?

[FLYFRG]

here is my file with macros

[nankw83]

Ok, revised code ...

Please Login or Register  to view this content.

[FLYFRG]

you are awesome!! however i notice that if numbers are in currency format it doesn't do the trick- it only works if theyre numbers like 22.4456 but if its $22.4456 nothing happens

[FLYFRG]

also is it possible to see the commas still? like i want 2599.66 to become 2,600 not 2600

THANK YOU

[nankw83]

The code does work on currency as you can see in attached file ... In addition, it will retain the original number format of the cell. If it was "general" then it won't show the thousand comma separator .. Check the attached file

[FLYFRG]

thank you so much- only issue is if i want lets say 1000 to appear as 1,000 it doesnt show that - any way to "force" it to show commas regardless if original number format of cell was general of whatever?

[nankw83]

Add below line in red

Please Login or Register  to view this content.

[FLYFRG]

you are a legend my friend- thank you

[nankw83]

Glad I could help .. If that takes care of your question, please take a moment & mark this thread as [SOLVED] from the Thread Tools above your first post

[FLYFRG]

only issue is if i have lets say a date somewhere in workbook 11/22/2005- the macro will pull that and convert to number like 51442 - how do we avoid that ?