Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-11-2011, 12:22 PM
mcook mcook is offline Adding comma to a custom type. Windows 7 64bit Adding comma to a custom type. Office 2010 32bit
Novice
Adding comma to a custom type.
 
Join Date: Aug 2011
Posts: 1
mcook is on a distinguished road
Default Adding comma to a custom type.


I am using excel 2010 and having a problem figuring this out. I have a number like 123456, i needed to add a decimal in front of the last 2 digits. I used #"."#0 in the Custom types, now i need to add the comma so the number shows as 1,234.56. Can anyone help?
Reply With Quote
  #2  
Old 08-13-2011, 03:08 AM
Catalin.B Catalin.B is offline Adding comma to a custom type. Windows Vista Adding comma to a custom type. Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

why dont you use a formula in another column to divide the numbers with 100, and just format the number to show separator for thousands to show your number as you wish?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding comma to a custom type. Adding Image into a excel cell and adding a hyperlink to the image saravananiyyanar Excel 3 05-04-2011 08:31 AM
How do I get rid of this type of symbol jerry1234 Word 1 09-04-2010 05:39 PM
adding a comma in end of each line in word juanb007 Word 0 07-23-2010 01:28 PM
Word won't let me type t, c, h, v laxation Word 0 04-22-2010 12:51 AM
Adding comma to a custom type. thousands comma separator taylormayd Excel 3 02-20-2009 03:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:18 AM.


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