Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Custom format 4 digit number to 0:00 Custom format 4 digit number to 0:00
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-05-2021, 04:30 PM
Marcia's Avatar
Marcia Marcia is offline Custom format 4 digit number to 0:00 Windows 10 Custom format 4 digit number to 0:00 Office 2019
Expert
Custom format 4 digit number to 0:00 		 
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Custom format 4 digit number to 0:00

Hi. Is there a way to format a number, say when the number 230 is entered, 2:30 should appear and 1130 to 11:30? I tried typing #0:00 in the custom format option but got an error message.
Thank you.
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
isolate the last digit of each number. joni Excel Programming 2 06-25-2020 04:12 AM
Custom format 4 digit number to 0:00 A challenging digit by digit manipulation, rotate the digit in range of 0 to 9 laucn Excel Programming 14 05-17-2015 12:12 PM
Custom format 4 digit number to 0:00 Creating a custom number format bremen22 Excel 2 01-16-2014 07:23 AM
Custom Number Format for Chart deadrxn24 Word 4 03-18-2012 05:38 PM
Custom format 4 digit number to 0:00 custom number format: change thousands separator Ward Excel 1 06-07-2011 08:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:09 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft