Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 10-01-2013
Member
 
Join Date: Jan 2013
Posts: 2
Excel 2010 changing number formats

can anyone help me please ??

i have a list of numbers in Column b which are say 1 but i want to change the number to read +001 how do i go about doing this, i have thousands tro change

Thanks
Reply With Quote
  #2  
Old 11-01-2013
Member
 
Join Date: Dec 2007
Posts: 2,273
Re: Excel 2010 changing number formats

I think that your Normal Style may be corrupted. So you can go to Styles in the Home Tab and right-ckick Normal. Specify modify and check the settings and make correction if necessary.
Reply With Quote
  #3  
Old 11-01-2013
Member
 
Join Date: Jan 2013
Posts: 2
Re: Excel 2010 changing number formats

i ws looking for a way to changethe form of the numbers without changing every single one
Reply With Quote
  #4  
Old 12-03-2013
Member
 
Join Date: Dec 2007
Posts: 1,728
Re: Excel 2010 changing number formats

I have found a VBA macro script that you can run to clean up the custom style list. You can try to create it in a macro, it is kind of slow, though it works:

Code:
Sub TrimStyles()
Dim s As Variant
Dim g As Style
On Error Resume Next
With ActiveWorkbook
For Each g In .Styles
If g.BuiltIn = False Then
s = g.Value
.Styles(s).Delete
End If
Next g
On Error GoTo 0
End With
End Sub
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel 2010 changing number formats"
Thread Thread Starter Forum Replies Last Post
Converting the floating point number to the hexadecimal on the Microsoft Excel 2010 Aag-Man Windows Software 5 11-07-2011 10:38 AM
Change mobile service provider without changing number ^Saraniya^ India BroadBand 5 02-01-2011 06:47 PM
Excel 2007 impulsively formats whole work book in date format foraman Windows Software 5 29-11-2010 11:14 PM
Want the same Number after changing location Gyani23 India BroadBand 2 01-04-2009 11:50 AM
Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats Bob Server Update Service 5 17-01-2008 02:35 AM


All times are GMT +5.5. The time now is 08:16 PM.