Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Changing a spreadsheet from # stored as text to stored as #? Changing a spreadsheet from # stored as text to stored as #?
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 02-08-2017, 07:43 AM
xor xor is offline Changing a spreadsheet from # stored as text to stored as #? Windows 10 Changing a spreadsheet from # stored as text to stored as #? Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Put a 1 in for example G2.
Take a copy of G2.
Sect A3:F70.
Right click and Paste Special.
Check Multiply.
OK.

Select A3:A70.
Format as date.
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing a spreadsheet from # stored as text to stored as #? location of where fonts are stored? aaronep Word 3 10-10-2013 08:22 AM
Changing a spreadsheet from # stored as text to stored as #? Printer parameters stored where? Doc_man Office 2 06-20-2011 12:27 PM
outlook 2003 - where are rules stored? Newmarket2 Outlook 1 02-13-2011 07:05 AM
Changing a spreadsheet from # stored as text to stored as #? Anyone know where Outlook would have stored sent emails? causton81 Outlook 2 01-27-2011 12:46 PM
Changing a spreadsheet from # stored as text to stored as #? Open .pst file that is stored online vincet2011 Outlook 2 01-14-2011 01:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:25 PM.

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