Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-06-2023, 07:18 AM
Sunil Pinto Sunil Pinto is offline Format Cell-Change Windows 10 Format Cell-Change Office 2010
Novice
Format Cell-Change
 
Join Date: Jul 2023
Posts: 2
Sunil Pinto is on a distinguished road
Default Format Cell-Change

Dear MS-Excel Forums,



Please help me to solve this problem.

I had the text data in excel having around 1000 rows of number. Say for example bank account number.

Some of the number are starting with natural numbers, but many numbers are starting with zero's, it may be staring with one or many zeros.(Example 023829, 00382741,128407439)
If your number is start with zeros than top-left side of the cell is prompting you to convert the format of the cell as number. Accidently I converted as number and saved.

Now the problem, I want to get the numbers with zero's back. I would have tried by using functions, if I had my previous data of certain digits (say for example my previous data digits are fixed for 8 only) But this case my data contains different number digits.

Is there any way out to get the previous data back. Other side data which typed is manually, (let Microsoft can change the formatting which ever we opted. But should not allowed to change the base data which we typed-Hope this should be the basic principle)

Please let me know you have any way get back this data


Thanks & Regards,

Sunil Pinto.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Cell-Change Need formula to format one cell if another cell includes specific text Bigsur2 Excel 2 11-17-2022 11:53 AM
Format Cell-Change Change active cell after running macro in active cell via selection change Peterson Excel Programming 3 03-07-2021 12:19 PM
Forcing format change or copying format only KDuncan Word 4 04-28-2020 08:26 AM
Format Cell-Change Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow FUGMAN Excel Programming 7 02-05-2017 08:37 AM
Change from General Format to number format gbaker Excel 3 08-16-2013 01:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:23 AM.


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